freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Invalid Cursor State By SELECT after INSERT

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

[freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
- Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
  - Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
    - Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
      - Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, James K. Lowden, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, Frediano Ziglio, 07/23/2008
        
        Re: [freetds] Invalid Cursor State By SELECT after INSERT, John Mazza, 07/23/2008