freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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.
-
[freetds] FreeTDS and MSSQL,
Venkat Lak, 04/20/2008
-
Re: [freetds] FreeTDS and MSSQL,
James K. Lowden, 04/20/2008
-
Re: [freetds] FreeTDS and MSSQL,
Venkat Lak, 04/20/2008
- Re: [freetds] FreeTDS and MSSQL, James K. Lowden, 04/21/2008
-
Re: [freetds] FreeTDS and MSSQL,
Venkat Lak, 04/20/2008
-
Re: [freetds] FreeTDS and MSSQL,
James K. Lowden, 04/20/2008
Archive powered by MHonArc 2.6.24.