Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS and MSSQL

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Venkat Lak <v_lak AT yahoo.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FreeTDS and MSSQL
  • Date: Sun, 20 Apr 2008 02:12:48 -0700 (PDT)

Hi

I use FreeTDS 0.63 to access a MSSQL server 2000 (version
8.00.2039). It connects fine and my queries work except for
one - when I use a GUID string (a varchar column) in the
where clause it fails:

select * from table where tid='bb8c5fe8-5e25-4181-8c3f-9ed12b6f9eb7-ed';

However, when I do:

select * from table where tid>='bb8c5fe8-5e25-4181-8c3f-9ed12b6f9eb7-ed';

it works ! It also works for '>','<','<=' and '<>' comparison
operators - just that '=' fails. In the tds dump I get:

dblib.c:4297:dbsqlok(010B7BC0)
net.c:363:error: select(2) returned 0x2726, "Unknown error"
util.c:328:tdserror(010B7A08, 010B8340, 20004, 10022)
dblib.c:7583:dbperror(010B7BC0, 20004, 0)
dblib.c:7646:"Read from the server failed", client returns 2 (INT_CANCEL)
util.c:364:tdserror: client library returned TDS_INT_CANCEL(2)
util.c:385:tdserror: returning TDS_INT_CANCEL(2)
util.c:157:Changed query state from PENDING to DEAD

I have tried using 'UTF-8' as 'client charset' in freetds.conf, but
it does not work.

I would appreciate any help to fix the above.

Thanks in advance,
Venkat


---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
now.




Archive powered by MHonArc 2.6.24.

Top of Page