[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