Re^2: ODBC Error - Invalid Cursor State (SQL-24000)

I ran into the same Invalid Cursor State (SQL-24000) error while using freetds. The only way I could get my program to run error-free was to connect and disconnect from the database for every iteration through a while loop. Ugly, bad form, abhorrent, yes, but it works.

It seems that this points to an incorrect reset of the cursor when a statement handle is finished running, though I've no clue how to fix it...

Comment on Re^2: ODBC Error - Invalid Cursor State (SQL-24000)

Replies are listed 'Best First'.
Re^3: ODBC Error - Invalid Cursor State (SQL-24000) by Anonymous Monk on Mar 18, 2011 at 19:32 UTC
I also saw this using FreeTDS. It was while reading through a result set in a while loop. My stored proc returned two sets of data (2 SELECTs). When I fit all of the data into a single SELECT that particular error went away.	[reply]
Re^4: ODBC Error - Invalid Cursor State (SQL-24000) by mje (Curate) on Mar 21, 2011 at 10:16 UTC
You need to look at odbc_more_results. You need to call it to skip to the next result-set. You also need to call it until it returns false to guarantee getting output parameters. See Connecting Perl on UNIX or Linux to Microsoft SQL Server - Perl DBI/DBD::ODBC Tutorial Part 3 which has examples of procedures returning multiple result sets under "Procedures Generating Multiple Result-Sets".	[reply]