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
