PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: John Gilmore-Baldwin <john at dwx dot com>
Subject: AutoCommitt and DBD::Sybase
Date: Jun 11 1999 9:53PM

I'm using DBD-Sybase-0.17 and it seems to be working fine.  However, the
server prints out this error message with every query:

commit ineffective with AutoCommit at
/usr/local/lib/perl5/site_perl/5.005/RPC/PlServer.pm line 329.

Here's my test script:

#!/usr/local/bin/perl

use DBI;

my $dbh =
DBI->connect("dbi:Proxy:hostname=197.133.247.18;port=7100;dsn=dbi:Syba
se:server=NEWS_SERVER", "user", "password");

my $sth = $dbh->prepare(q{select id,name from news..story where name like
'11t%'
}) || die "Can't execute statement: $DBI::errstr";

my $rc = $sth->execute || die "Can't execute statement: $DBI::errstr";

while (($id, $name) = $sth->fetchrow_array)
{
    print "$id: $name\n";
}

die $sth->errstr if $sth->err;

$dbh->disconnect;