Skip to Content.
Sympa Menu

freetds - [freetds] FreeTDS and SQL server 2005

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Pieter Rautenbach" <parautenbach AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] FreeTDS and SQL server 2005
  • Date: Mon, 29 May 2006 14:56:55 +0200

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




Archive powered by MHonArc 2.6.24.

Top of Page