FreeTDS Development Group

["Thompson, Bill D (London)" <bill_d_thompson AT ml.com>]

Hi Pieter,

Could you capture and publish a TDSDUMP log file for the successful and
unsuccessful tests ?

Thanks,

Bill

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Pieter
Rautenbach
Sent: 29 May 2006 13:57
To: freetds AT lists.ibiblio.org
Subject: [freetds] FreeTDS and SQL server 2005


Hello Mailing List,

I've been using FreeTDS 0.63 without problems with MS SQL server 2000.
I've just setup CentOS and configured FreeTDS with unixODBC and want
to connect to a MS SQL server 2005 database. I can connect to the DB
with both tsql and isql. However, if I set TDS_Version to 8.0 in my
odbc.ini, I get the following error:

SQL> select getdate();
[ISQL]ERROR: Could not SQLPrepare

If I change TDS_Version to 4.2 or 7.0 the above works.

SQL> select getdate();
+-------------------------+
|                         |
+-------------------------+
| 2006-05-29 14:56:12.330 |
+-------------------------+
SQLRowCount returns 1
1 rows fetched

I would like to know whether anyone has experienced a similar problem
before or could perhaps point me to the relevent documentation if I
have missed something obvious.

Any help would be greatly appreciated.

Pieter Rautenbach
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the 
sender, delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------