I keep getting this error when attempting to utilize a database that has Innodb tables, and using transactions. This is from a Perl/DBI script too:
Error: Transactions not supported by database at module..... bla..bla
MySQL Version: 4.0.17-standard - Official MySQL-standard binary
and it has innodb enabled, the autocommit is set to 1 on the inital 'connect', no errors, then when the transaction is executed, the autocommit is set to 0 until the commit is called, of if an error occurs, the rollback is called.
Is there something in the variables I can check to make sure transaction have been enabled for this particular database ??
Any help or suggestion appreciated :)
TIA -- Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
