RE: Transactions not supported by database - Perl
I have expereience the same behaviour when using the ppm from activestate. Try using the one below, seem to work for me... ppm install http://theoryx5.uwinnipeg.ca/ppmpackages/DBD-mysql.ppd -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 14, 2002 9:33 PM To: Bob Boden Cc: [EMAIL PROTECTED] Subject: Re: Transactions not supported by database - Perl Send the set autocommit=0 just as you send any other query in perl. Bob Boden wrote: 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 - 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 - 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
Re: Transactions not supported by database - Perl
Anyone know of an email marketing software suite that works well with MySQL on the backend? I've seen stuff that works with ODBC db connectivity but I'm not interested in moving to MS SQL or Access. Any feedback is appreciated Thanks Mark - 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
Re: Transactions not supported by database - Perl
Send the set autocommit=0 just as you send any other query in perl. Bob Boden wrote: 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 - 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
Transactions not supported by database - Perl
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