[freetds] Connection Errors
Curt Kiser
ckiser at wi.rr.com
Tue Jul 5 14:40:53 EDT 2005
I keep getting the following error even if I get a successful connection to
the database.
Server message number=3902 severity=16 state=1 line=2 server=CHWWE
BDB2 text=The COMMIT TRANSACTION request has no corresponding BEGIN
TRANSACTION.
Versions:
MSSQL 2k sp3
TDS Version = 0.63 (TDSVER=8.0)
DBD::Sybase = 1.05
DBI = 1.48
Here is what I'm using for my connection call.
my $dbh;
my $Uname = 'username';
my $Pword = 'password';
my $Server = 'myserver.chw.org';
my $Dbase = 'curtsbox';
my %attr = (
PrintError => 0,
RaiseError => 0,
);
print "Connection Error:".$DBI::err."\n\n";
my $dbh = DBI->connect(
"DBI:Sybase:server=$Server;
database=$Dbase",$Uname,$Pword,\%attr ) or die ;
print "Connection Error:".$DBI::err."\n\n";
It looks like after a use curtsbox is executed a commit is sent ot the
server but is never completed.
Any help would be appreciated.
Thanks, Curt
More information about the FreeTDS
mailing list