Re: Invalid cursor state

Attached here is the log generated by freeTDS. I didn't know about this log.
It has details related to the error.

Versions of the installed packages:

freeTDS - Latest version released on 4th March 2010
unixODBC-2.2.14-p2   (It is the latest version)
Sql Server 2005

Thanks.




On Thu, Mar 11, 2010 at 12:27 PM, Swapnil Shinde <[email protected]>wrote:

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