Skip to Content.
Sympa Menu

freetds - [freetds] Connection Errors

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Curt Kiser" <ckiser AT wi.rr.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Connection Errors
  • Date: Tue, 5 Jul 2005 13:40:53 -0500

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









  • [freetds] Connection Errors, Curt Kiser, 07/05/2005

Archive powered by MHonArc 2.6.24.

Top of Page