[freetds] Invalid Cursor State By SELECT after INSERT

John Mazza john.mazza at mgcworks.com
Wed Jul 23 12:54:32 EDT 2008


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






More information about the FreeTDS mailing list