Skip to Content.
Sympa Menu

freetds - RE: [freetds] Re: SQLRowCount failing after prepare and execute (PaulSteward)

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Re: SQLRowCount failing after prepare and execute (PaulSteward)
  • Date: Fri, 20 Feb 2004 14:18:12 +0100

>
> 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

This is another problem relate to multiple statement and row count
caching. It seem that every statement cache row count.

freddy77



  • RE: [freetds] Re: SQLRowCount failing after prepare and execute (PaulSteward), ZIGLIO, Frediano, VF-IT, 02/20/2004

Archive powered by MHonArc 2.6.24.

Top of Page