FW: DBI/DBD won't recognize transaction support

> Greetings
> 
> I am trying to get the perl interface to work for InnoDB tables on mysql v 5.0.21, perl 5.8.5, dbi 1.51, dbd 3.0004_1 on a Dell PowerEdge with quad dual-core Xeons running Redhat Enterprise v4. I can create an InnoDB table from the mysql command line, insert a row, see it's there, rollback, see the row is gone. But the simple script below fails:
> 
> use DBI;
> my $user = 'root';
> my $pw = ;
> my $dbh = DBI->connect("DBI:mysql:database=test;host=127.0.0.1", $user, $pw, { AutoCommit => 0, RaiseError => 0 });
> die DBI::errstr unless $dbh;
> $dbh->disconnect;
> 
> The DBI/DBD interface is working OK for other (non-InnoDB) scripts.
> 
> DBI passes all it's tests except for those that complain about DBI::PurePerl. DBD passes all of its tests except the one that deals with transactions. Can anyone offer a suggestion how to isolate the problem? SHOW ENGINES indicates that InnoDB is indeed enabled and actions with InnoDB from the mysql command line work OK. Should I make InnoDB the default table type when I start the server? Am I simply hosed because of multi-threading?
> 
> Thanks
> 
> Mike
>