[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