Skip to Content.
Sympa Menu

freetds - [freetds] Invalid cursor state when executing 2 SELECT statements

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Sebastien FLAESCH <sf AT 4js.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Invalid cursor state when executing 2 SELECT statements
  • Date: Thu, 13 Dec 2007 11:45:06 +0100

Dear all,

I just want to:

SQLPrepare(stmt1, "SELECT ...");
SQLPrepare(stmt2, "SELECT ...");
SQLExecute(stmt1);
SQLExecute(stmt2);

But second SQLExecute() returns "Invalid cursor state".

I must either issue an SQLFetch() or SQLCloseCursor() with the first statement
to be able to execute the second one.

Is this a known limitation of the FreeTDS ODBC driver?

Thanks
Seb




Archive powered by MHonArc 2.6.24.

Top of Page