[freetds] FreeTDS and SQL server 2005
Pieter Rautenbach
parautenbach at gmail.com
Fri Jun 2 05:16:00 EDT 2006
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
>
More information about the FreeTDS
mailing list