[freetds] MS SQL Server 2005 and FreeTDS
Jeff Dahl
jddahl at micron.com
Fri Feb 10 20:01:02 EST 2006
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
More information about the FreeTDS
mailing list