[unixODBC-support] DBD::ODBC::st fetchrow_hashref failed: Unable to fetch information about the error

Nick Gorham nick at lurcher.org
Fri Apr 15 20:35:06 BST 2011


On 15/04/2011 20:06, eric.berg at barclayscapital.com wrote:
>
> Perl 5.12.3
>
> DBI 1.11
>
> DBD::ODBC 1.29
>
> FreeTDS 0.83 and 0.91
>
> unixODBC 2.3.0
>
> MS SQL Server  2008
>
> I'm running a stored procedure and getting the following message:
>
> DBD::ODBC::st fetchrow_hashref failed:     Unable to fetch information 
> about the error
>
> This code generates this error:
>
> I get a dbh with a simple odbc dsn:  dbi:ODBC:MSSQL
>
> my $sql = "EXECUTE point_port..api_IRunCommit NULL, 13272";
>
> my $sth = $dbh->prepare($sql);
>
> $sth->execute;
>
> warn "Errors: " . $sth->errstr . "\n";
>
> while ( my $stuff = $sth->fetchrow_hashref() ) {
>
>     warn Dumper($stuff);
>
> }
>
> It dies on the first iteration of the while loop.  Here's what I get:
>
> Errors: [FreeTDS][SQL Server]Apr 15 2011  3:00:42:683PM - nothing to 
> commit (SQL-01000)
>
> [FreeTDS][SQL Server]Apr 15 2011  3:00:42:683PM : rows 
> affected          1 - calculated max_range (SQL-01000)
>
> [FreeTDS][SQL Server]Apr 15 2011  3:00:42:680PM : rows 
> affected          1 - UPDATE  point_hist..pricing_request (SQL-01000)
>
> [FreeTDS][SQL Server]Apr 15 2011  3:00:42:680PM - cleared old bad 
> records (SQL-01000)
>
> [FreeTDS][SQL Server]Apr 15 2011  3:00:42:673PM : rows 
> affected          1 - retrieved old max (SQL-01000)
>
> DBD::ODBC::st fetchrow_hashref failed:     Unable to fetch information 
> about the error
>

Not sure, I guess I would ask the freeTDS and DBD::ODBC folk. unixODBC 
is just a interested observer in the above events.

-- 
Nick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20110415/e3082c29/attachment.html>


More information about the unixODBC-support mailing list