Skip to Content.
Sympa Menu

freetds - [freetds] Re: Transactions errors with DBD-Sybase-1.05

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: David Barnwell <david.barnwell AT well.ox.ac.uk>
  • Cc: sybperl-l AT peppler.org, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Re: Transactions errors with DBD-Sybase-1.05
  • Date: Tue, 22 Mar 2005 20:12:33 +0100

On Tue, 2005-03-22 at 20:04, David Barnwell wrote:
> Hi,
>
> I've hit some problems executing transactions and rollbacks with
> DBD-Sybase-1.05 and FreeTDS 0.63RC10. My client system runs Red Hat
> Enterprise Linux 3 and perl-5.8.0-88.4, and the server is SQL Server 2000.
>
> The code I use is based on the example in DBI.pm. The central part is:
>
> $dbh->{AutoCommit} = 0;
> $dbh->{RaiseError} = 1;
>
> eval {
> my $sth = $dbh->prepare($sql);
> $sth->execute;
> $sth->finish;

Why do you call finish() here?

> $dbh->commit;
> };
> if ($@) {
> eval { $dbh->rollback };
> }
>
> The SQL statement executes a stored procedure that updates a table. This
> works fine with DBD-Sybase-1.04 and FreeTDS 0.63RC10. The procedure is
> executed OK and the table is updated.
>
> However, the program fails with DBD-Sybase-1.05. The SQL is executed and
> the table is updated, but the transaction fails with the following error
> message:
>
> Attempt to initiate a new SQL Server operation with results pending

Please post (or send me) a trace with DBI->trace(5).

Michael
--
Michael Peppler - mpeppler AT peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html






Archive powered by MHonArc 2.6.24.

Top of Page