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: "Michael Warchut" <mike AT warchut.com>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Invalid Cursor State
  • Date: Wed, 4 Feb 2009 20:16:46 -0800

Thanks James

I actually just tracked the issue down. We are running dg4odbc on top of
FreeTDS. It seems that the problem was generated by a SQLStatistics call
coming from there. I disabled this function in the init file and now the
queries appear to work all of the time.



-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of James K. Lowden
Sent: Wednesday, February 04, 2009 6:37 PM
To: FreeTDS Development Group
Subject: Re: [freetds] Invalid Cursor State

Michael Warchut wrote:
> I am making great headway but have run into an issue. When trying to
> do a select and an insert my connection crashes with this in the logs..
>
> [[FreeTDS][SQL Server]Invalid cursor state]

Use TDSDUMP to see the session. I expect you'll find a server error
message in there that your appplication isn't displaying.

But I'm going out on a limb and tell you you'll find a SYBERPND error.
You must retrieve all results before turning around and issuing a new SQL
query. See the FAQ for further details.

(Just trying to help. Apologies if you already knew.)

--jkl

_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page