Skip to Content.
Sympa Menu

freetds - [freetds] Invalid cursor state

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Swapnil Shinde <swapnil34 AT gmail.com>
  • To: FreeTDS AT lists.ibiblio.org
  • Subject: [freetds] Invalid cursor state
  • Date: Thu, 11 Mar 2010 12:27:30 -0500

I am stuck at a step and will appreciate your suggestion.



I am using a combination of Snort+unixODBC+freeTDS+mssql. Everything is
working fine except freeTDS is giving me following error for every query
after the first query made by the Snort.



*DIAG [24000] [FreeTDS][SQL Server]Invalid cursor state *

{This line is taken from unixODBC trace}



After doing some research; I have found that in order to do multiple queries
at faster rate; one needs to enable MARS (Multiple Active Result Sets)
parameter in the connection API of mssql. If it is not done in this fashion;
then one may get the above error.



Now, can you tell me if I am on the right track and when would you guys be
able to come up with this correction? Also, you can let me know the code
where connection APIs are used and I can make changes if you want. (I can do
these changes; I have already made minor changes in Snort code in order to
make this combination work). Any direction over this problem would be
appreciated.



Thanks in advance.




Archive powered by MHonArc 2.6.24.

Top of Page