[freetds] FreeTDS and MSSQL

Venkat Lak v_lak at yahoo.com
Sun Apr 20 05:12:48 EDT 2008


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.



More information about the FreeTDS mailing list