Skip to Content.
Sympa Menu

freetds - [freetds] Invalid Cursor State By SELECT after INSERT

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "John Mazza" <john.mazza AT mgcworks.com>
  • To: "freetds AT lists.ibiblio.org" <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Invalid Cursor State By SELECT after INSERT
  • Date: Wed, 23 Jul 2008 12:54:32 -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!!!







Archive powered by MHonArc 2.6.24.

Top of Page