I dont think that transactions are supported (yet?) by the PERL DBI. /Jonas
----- Original Message ----- From: "Mike Blezien" <[EMAIL PROTECTED]> To: "MySQL List" <[EMAIL PROTECTED]> Sent: Tuesday, March 30, 2004 9:42 PM Subject: Transaction Not supported > 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 > > I realize this maybe a DBI question, but I thought I'd check here first incase > we missed something is the settings for the MySQL server > > Version: 4.0.17-standard - Official MySQL-standard binary > and it has innodb enabled, the autocommit is set to 1, then when the transaction > is executed, the autocommit is set to 0 untill the commit is called.... > > Is there something in the variables I can check to make sure transaction have > been enabled ?? > > 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] > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]