Attempts to disable auto-commit mode in Perl using the DBI command $dbh->{AutoCommit} = 0; returns the following message, "Transactions not supported by database".
I am using the latest version of MySQL-Max (3.23.51) as well as the latest version of DBD::mysql. Executing the following command at the mysql prompt verifies that BDB Transaction enabled tables are supported and turned on. mysql> SHOW VARIABLES LIKE "have_%"; +---------------+----------+ | Variable_name | Value | +---------------+----------+ | have_bdb | YES | | have_gemini | NO | | have_innodb | DISABLED | | have_isam | YES | | have_raid | NO | | have_openssl | NO | +---------------+----------+ 6 rows in set (0.00 sec) Executing SET AUTOCOMMIT=0; at the mysql prompt works fine as well. However, I can not get Perl scripts to recognize the disable auto-commit command. These symptoms are occurring in a Linux/apache web server as well as a Windows 2000 environment running as "localhost". Any suggestions would be greatly appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php