(no subject)

"John Mazza" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
I'm seeing a problem with 0.82 (daily, 2007-07-22) where a SELECT
following an INSERT will cause an Invalid Cursor State error to occur.

===================
INSERT INTO FaxJob (FaxDeptID, FaxSendToNo, FSID, FaxResultID,
FaxSendTries,recip_id,SendImmediate, FaxEmployeeID, FaxCreate) VALUES(
-8151396, '4123880569', 5,0,0,0,0,0,'2008-07-22 22:36:24')

SELECT FaxJob.FaxJobID FROM FaxJob WHERE FaxJob.FaxDeptID = -8151396

RESULT:

[FreeTDS][SQL Server]Invalid cursor state; Record 2: SqlState: 24000;
NativeError: 0; Message: [FreeTDS][SQL Server]Invalid cursor state;

====================

Does anyone have any ideas on how to solve this one?  

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