Skip to Content.
Sympa Menu

freetds - Re: [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: Re: [freetds] Invalid cursor state
  • Date: Thu, 11 Mar 2010 15:24:18 -0500

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 <swapnil34 AT gmail.com>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.
>
>




Archive powered by MHonArc 2.6.24.

Top of Page