DBD driver has not implemented the AutoCommit attribute ...



I've STFW for this error & got back many results but did not find
anything relevant to the problem I think I'm having.

Perl script on windows-xp (perl 5.8.6.811, DBI 1.50, DBD-mysql 3.0002)
trying to connect to a mysql server on a unix box running
mysql-3.22.32-sun-solaris2.7-sparc.

use DBI;
$::my_db =
DBI->connect("DBI:mysql:$db_name:$unix_db_host",$db_user,$db_pass,
{ RaiseError => 1, PrintError => 0, AutoCommit => 0 })
|| die DBI->errstr;

Executing this returns the error message. Fiddling with the AutoCommit
setting gives the same result. If I fiddle with the db_name (use
non-existant db), I get the correct response back (unknown database) so
I believe that I am interacting with the remote mysql server.

The DBI->trace is below (I've ****'d out the dbname, host, user,
password);

DBI 1.50-ithread default trace level set to 0x0/2 (pid 3356)
-> DBI->connect(DBI:mysql:****:****, ****, ****, HASH(0x235140))
-> DBI->install_driver(mysql) for MSWin32 perl=5.008006 pid=3356
ruid=0 euid=0
install_driver: DBD::mysql version 3.0002 loaded from
C:/Perl/site/lib/DBD/mysql.pm
<- install_driver= DBI::dr=HASH(0x1868270)
-> connect for DBD::mysql::dr (DBI::dr=HASH(0x1868270)~0x196f7bc
'****:****' '****' **** HASH(0x199ada0)) thr#23418c
imp_dbh->connect: dsn = ****:****, uid = ****, pwd = ****
imp_dbh->my_login : dbname = ****, uid = ****, pwd = ****,host = ****,
port = NULL
imp_dbh->mysql_dr_connect: host = |****|, port = 0, uid = ****, pwd =
****
imp_dbh->mysql_dr_connect: client_flags = 2
imp_dbh->mysql_dr_connect: <- -> STORE for DBD::mysql::db
(DBI::db=HASH(0x199ad94)~INNER 'mysql_auto_reconnect' 1) thr#23418c
<- STORE= 1 at mysql.pm line 143
<- connect= DBI::db=HASH(0x196f798) at DBI.pm line 617
-> STORE for DBD::mysql::db (DBI::db=HASH(0x199ad94)~INNER
'RaiseError' 1) thr#23418c
<- STORE= 1 at DBI.pm line 664
-> STORE for DBD::mysql::db (DBI::db=HASH(0x199ad94)~INNER
'PrintError' 0) thr#23418c
<- STORE= 1 at DBI.pm line 664
-> STORE for DBD::mysql::db (DBI::db=HASH(0x199ad94)~INNER
'AutoCommit' 0) thr#23418c
Turning off AutoCommit failed error 21 recorded: Turning off AutoCommit
failed
-> DESTROY for DBD::mysql::db (DBI::db=HASH(0x199ad94)~INNER)
thr#23418c
&imp_dbh->mysql: 199b3ac
ERROR: 21 'Turning off AutoCommit failed' (err#0)
<- DESTROY= undef at DBI.pm line 664
-- DBI::END
-> disconnect_all for DBD::mysql::dr
(DBI::dr=HASH(0x1868270)~0x196f7bc) thr#23418c
<- disconnect_all= (not implemented) at DBI.pm line 692
! -> DESTROY in DBD::_::common for DBD::mysql::dr
(DBI::dr=HASH(0x196f7bc)~INNER) thr#23418c
! <- DESTROY= undef during global destruction

I think there is a compatibility issue with the old mysql server. Does
this seem reasonable or am I FOS? If you think I'm right, what can I do
to connect short of upgrading the server (I don't own it & I had to beg
for a user/password). To complicate matters - my perl script also
connects to other newer servers (4.1.11-nt).

Thanks in advance for any help.

/ron

.