Skip to Content.
Sympa Menu

freetds - Re: [freetds] MS SQL Server 2005 and FreeTDS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS SQL Server 2005 and FreeTDS
  • Date: Sun, 12 Feb 2006 15:12:48 +0100

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? Does myTable contain 'data1' and 'data2' ?

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






Archive powered by MHonArc 2.6.24.

Top of Page