On 18 Feb 2002, at 9:04, Thomas, Eldho wrote:

> When I use,
> $dbh = DBI->connect("dbi:Informix:database", {PrintError => 1,
> AutoCommit => 0}); the transaction doesn't seem to start and all the
> updates are committed immediately and a "commit" or "rollback"
> statement gives a "Not In Transaction" error.
> 
> But, if I do it using two statements as below, it seems to work fine.
> $dbh = DBI->connect("dbi:Informix:database", {PrintError => 1});
> $dbh->{AutoCommit}=0;
> 
> 
> Is there anything I am missing in the first case ?

You put the attributes hashref in the place where DBI expects the 
$user. Try

my $dbh = DBI->connect("dbi:Informix:database", undef, undef, 
{PrintError => 1, AutoCommit => 0});

> Thanks.
> Eldho Thomas
> Enterprise Rent-A-Car.

HTH

Bodo


Reply via email to