Re: Invalid Cursor State

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: [email protected]
[mailto:[email protected]] 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
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds