freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] (no subject)

From: "John Mazza" <john.mazza AT mgcworks.com>
To: "Invalid Cursor State By SELECT after INSERT" <"Invalid CursorStateBySELECTafterINSERT"@lists.ibiblio.org>, "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
Subject: [freetds] (no subject)
Date: Wed, 23 Jul 2008 12:53:07 -0400

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

[freetds] (no subject), John Mazza, 07/23/2008