On Tue, 30 Mar 2004, Mike Blezien wrote: > Hello, > > 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 >
What version of DBD::mysql are you using? > > 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 ?? > You can use transactions with non-innodb tables, IIRC. You will just get warnings on rollback. Rudy
