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: Jeff Dahl <jddahl AT micron.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] MS SQL Server 2005 and FreeTDS
  • Date: Mon, 13 Feb 2006 09:13:10 -0700



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






Archive powered by MHonArc 2.6.24.

Top of Page