RE: Transactions not supported by database - Perl

2002-08-15 Thread Shao Ming 


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

2002-08-15 Thread Mark Stringham 

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

2002-08-14 Thread Gerald Clark 

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