[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