[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