freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Re: SQLRowCount failing after prepare and execute (Paul Steward)

From: "Paul Steward" <Paul.Steward AT infospace.com>
To: <freetds AT lists.ibiblio.org>
Subject: [freetds] Re: SQLRowCount failing after prepare and execute (Paul Steward)
Date: Mon, 16 Feb 2004 10:21:13 -0800

Patrick,

You're right, there is a problem with SQLRowcount. I run the following
in Perl 5.6.1 under FreeTDS 0.62.1.

my $sql = 'CREATE TABLE #PERL_DBD_TABLE1 (id INT PRIMARY KEY, val
VARCHAR(4))'; $sth = $dbh->prepare($sql); $sth->execute; $sth->finish;

And it errors out with the statement:

DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid
cursor state (SQL-24000)(DBD: st_execute/SQLRowCount err=-1) at
t/20SqlServer.t line 124.

The standard details:
unixODBC 2.2.6
FreeTDS 0.62.1
Debian Linux 3.0 kernel 2.4.21
DBI 1.40
DBD::ODBC 1.06
SQL Server 2000 SP4

[freetds] Re: SQLRowCount failing after prepare and execute (Paul Steward), Paul Steward, 02/16/2004