Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: 32bit Win Apps on 64bit Systems with Transactions

Posted on 2011-10-11 12:19:00 by Erwin Brandenberger

I have ODBC problems von 64bit machines using transactions.

Following sample:

START TRANSACTION
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26471
SELECT ...
DELETE FROM INST_FOLDER WHERE INSTFOLDERID = 26475
....
DELETE FROM INSTRUMENT WHERE INSTID = 677469
-> SQLExecDirect Error 1451 - HY000 - [MySQL][ODBC 5.1
Driver][mysqld-5.1.47]Cannot delete or update a parent row: a foreign
key constraint fails (`PicosDbCl`.`INST_FOLDER`, CONSTRAINT
`fk_inst_folder_instrument` FOREIGN KEY (`INSTID`) REFERENCES
`INSTRUMENT` (`INSTID`))
DELETE FROM INSTRUMENT WHERE INSTID = 677470
-> SQLExecDirect Error 1451 - HY000 - [MySQL][ODBC 5.1
Driver][mysqld-5.1.47]Cannot delete or update a parent row: a foreign
key constraint fails (`PicosDbCl`.`INST_FOLDER`, CONSTRAINT
`fk_inst_folder_instrument` FOREIGN KEY (`INSTID`) REFERENCES
`INSTRUMENT` (`INSTID`))

The problem starts when I have to delete a few hundreds (about 700-800)
instruments.

On 32bit machines, everything works fine with the same binary.

For me it seams, that the transaction suddently is rollbacked by the
odbc driver.

I have similar problems on 64bit compiled linux binaries with 64bit
mysql odbc drivers, too.

What is the reason for ?
Can I take a fow settings ?



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Report this message