[freetds] Invalid cursor state when executing 2 SELECT statements
Sebastien FLAESCH
sf at 4js.com
Thu Dec 13 05:45:06 EST 2007
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
More information about the FreeTDS
mailing list