[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