[freetds] MS SQL Server 2005 and FreeTDS

Jeff Dahl jddahl at micron.com
Mon Feb 13 11:13:10 EST 2006



Frediano Ziglio wrote:

>Il giorno ven, 10/02/2006 alle 18.01 -0700, Jeff Dahl ha scritto:
>  
>
>>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
>>
>>    
>>
>
>Is difficult do reply to your question without knowing the tool you are
>using... I suppose is a ODBC tool like isql. Or is it a program you
>wrote? 
>
I wrote the program using the ODBC API.  However, if I run the same 
query with with tsql (v0.63 and CVS), the data is returned correctly.  
Looks like the problem is in the ODBC layer.

>Does myTable contain 'data1' and 'data2' ?
>  
>
Yes.

>0.63 version reply is wrong, while CVS is a bit... futuristic... We
>already started a new branch so CVS is not the next coming release but
>the release AFTER the coming release... However fixing problem before
>any release is feasible...
>
>freddy77
>
>
>_______________________________________________
>FreeTDS mailing list
>FreeTDS at lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>  
>


More information about the FreeTDS mailing list