[freetds] MS SQL Server 2005 and FreeTDS

Konrad J Hambrick konrad at mail2.payplus.com
Sat Feb 11 11:49:06 EST 2006


Jeff --

I think you need a ; or GO after each statement.

I think the DROP TABLE fails because there are
two pending ROWS from the SELECT statement ...

maybe ?

-- kjh


Jeff Dahl wrote:
> 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
> 
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
> 


More information about the FreeTDS mailing list