Skip to Content.
Sympa Menu

freetds - [freetds] MS SQL Server 2005 and FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jeff Dahl <jddahl AT micron.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] MS SQL Server 2005 and FreeTDS
  • Date: Fri, 10 Feb 2006 18:01:02 -0700

Why does this query

CREATE TABLE #data( myID varchar( 25 ))
INSERT into #data select myID from myTable where myID = 'data1'
INSERT into #data select myID from myTable where myID = 'data2'
CREATE index myindex on #data (myID)
SELECT myID
FROM #data, myTable
WHERE ( #data.myID = myTable.myID )
DROP TABLE #data

generate this error:

SQL_STATE: 24000
NATIVE_ERROR: 0
MSG: [FreeTDS][SQL Server]Invalid cursor state
MSG_LEN: 41

I've tried this with both 0.63 and the latest CVS version. Only the CVS
version gives the error. Version 0.63 doesn't return anything.

Thanks,
Jeff Dahl





Archive powered by MHonArc 2.6.24.

Top of Page