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