[freetds] Cannot connect to SQL6.5 with tsql

Eric Augustus gaugustu at cisco.com
Thu Dec 19 15:18:54 EST 2002


Thanks for the suggestion, but I did set the TDS version to 4.2. I
attempted setting it using the freetds.conf file and the envar TDSVER.

The TDSDUMP log showed it was set to version 4.2.

This works on the stable release, 0.60, but not the 12/16/02 CVS
snapshots. (I haven't tried the latest snapshot yet, but nothing in the
Changelog indicated this would matter anyway.)

Thanks,
gus

On Thu, Dec 19, 2002 at 02:57:36PM -0500, Daniel Morgan wrote:
> I'm only guessing here...
> 
> Try setting the TDS Version to 4.2
> 
> You can do this many ways:
> - rebuilding freetds to use tds version 4.2
>   for example:
>   $ ./configure --with-tdsver=7.0 --prefix=/opt/freetds
> 
> - in freetds.conf, set tds version to equal 4.2
>   for example:
>   [sqlserver65]
>      host = ntbox.mydomain.com
>      port = 1433
>      tds version = 4.2
> 
> - set environment variable TDSVER to equal 42
> 
>   for example in a bash shell:
>   $ export TDSVER=4.2
> 
>   for example in a csh shell:
>   $ setenv TDSVER 4.2
> 

-- 
----------------------------------------------------------
   Eric P. Augustus            | gaugustu at cisco.com       
   Network Security Engineer   | www.cisco.com
   Cisco Systems Inc.          | Voice: 512.378.1051
   12515 Research Blvd.        | Fax: 512.378.1425
   Austin, Texas  78759-2220   | Pager: 800.365.4578
----------------------------------------------------------
Truth can wait; he's used to it.



More information about the FreeTDS mailing list