32bit Win Apps on 64bit Systems with Transactions

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