Skip to Content.
Sympa Menu

freetds - Re: [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 Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS and SQL server 2005
  • Date: Fri, 2 Jun 2006 11:16:00 +0200

Hi Bill,

It seems like a made an error when installing unixODBC from sources.
TDS_Version = 8.0 works fine with MS SQL Server 2005. I'll notify the
list if I encounter any more problems.

Thanks for your help.
Pieter

On 5/30/06, Thompson, Bill D (London) <bill_d_thompson AT ml.com> wrote:
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/
--------------------------------------------------------
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds




  • Re: [freetds] FreeTDS and SQL server 2005, Pieter Rautenbach, 06/02/2006

Archive powered by MHonArc 2.6.24.

Top of Page