[freetds] Re: SQLRowCount failing after prepare and execute (PaulSteward)
ZIGLIO, Frediano, VF-IT
Frediano.Ziglio at vodafone.com
Fri Feb 20 08:18:12 EST 2004
> You're right, there is a problem with SQLRowcount. I run the
> 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.
More information about the FreeTDS