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

[Anonymous Monk]

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...

[Anonymous Monk]

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.

[mje]

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".