freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Invalid cursor state when executing 2 SELECT statements

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

[freetds] Invalid cursor state when executing 2 SELECT statements, Sebastien FLAESCH, 12/13/2007
- Re: [freetds] Invalid cursor state when executing 2 SELECT statements, Sebastien FLAESCH, 12/17/2007
  - Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, ZIGLIO, Frediano, VF-IT, 12/18/2007
    - Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, Sebastien FLAESCH, 12/18/2007
      - Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, ZIGLIO, Frediano, VF-IT, 12/19/2007
      - Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, ZIGLIO, Frediano, VF-IT, 12/21/2007
        
        Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, James K. Lowden, 12/21/2007
        
        Re: [freetds] Invalid cursor state when executing 2 SELECTstatements, Sebastien FLAESCH, 12/21/2007