[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
>
> 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
More information about the FreeTDS
mailing list