freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] dbresults() SUCCEEDs but dbnextrow() returns NO_MORE_ROWS

From: Roberto Sierra <rsierra AT gio.etsit.upm.es>
To: FreeTDS AT lists.ibiblio.org
Subject: [freetds] dbresults() SUCCEEDs but dbnextrow() returns NO_MORE_ROWS
Date: Tue, 14 Feb 2006 17:05:41 +0100

Hello to all,

I'm having a weird problem when connecting to a MSSQL server using FreeTDS.

After a rather involved query which, when performed manually yields several rows, dbresults() returns SUCCEED, but any other call like dbbind(), dbnextrow() or dbrows() FAILs. Weirdest of all, the exact same code ran ok with a previous version of freetds. Other queries apparently don't share this problem.

Anyone have some idea on what is the cause, or how to debug it?

Thanks very much in advance for your help.

Best regards,
Roberto Sierra.

[freetds] dbresults() SUCCEEDs but dbnextrow() returns NO_MORE_ROWS, Roberto Sierra, 02/14/2006