Re: Invalid Cursor State

"James K. Lowden" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.