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/[email protected]