sybperl-l Archive

From: "Peng, Ge" <Ge dot Peng at citadelgroup dot com>
Subject: RE: Can't turn off autocommit
Date: May 10 2005 7:03PM

It should be $dbh->{AutoCommit} = 0;

Your $dbh is an object and usually a Perl object is a blessed reference
to a hash.

________________________________

From: owner-sybperl-l@peppler.org [mailto:owner-sybperl-l@peppler.org]
On Behalf Of Wechsler, Steven
Sent: Tuesday, May 10, 2005 1:50 PM
To: 'sybperl-l@peppler.org'
Subject: Can't turn off autocommit

 

OK, this is more a DBI than a Sybperl question, but anyway, here's my
code: 

$dbh = DBI->connect("dbi:Sybase:server=$server", $login, $password, 
                    {PrintError => 1, AutoCommit => 1}); 
if (! $dbh) { 
    die "Can't connect to $server: $DBI::errstr\n"; 
} 

# do some stuff 
. 
. 
. 
$dbh->(AutoCommit) = 0; 

When the script hits that autocommit line, I get the message 
"Not a subroutine reference at myscript.pl line 175." 

Any ideas? 

Thanks, 

Steve 

------------------------------------------------------------------------
-------------------------
-------------------------

CONFIDENTIALITY AND SECURITY NOTICE

This e-mail contains information that may be confidential and 
proprietary. It is to be read and used solely by the intended
recipient(s). 
Citadel and its affiliates retain all proprietary rights they may have
in the 
information. If you are not an intended recipient, please notify us 
immediately either by reply e-mail or by telephone at 312-395-2100 
and delete this e-mail (including any attachments hereto) immediately 
without reading, disseminating, distributing or copying. We cannot give 
any assurances that this e-mail and any attachments are free of viruses 
and other harmful code. Citadel reserves the right to monitor, intercept
and block all communications involving its computer systems.