FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il giorno mar, 15/11/2005 alle 09.16 -0600, Bing Du ha scritto:
> Hello,
> 
> FreeTDS is new to me.  The questions I have are:
> 
> 1. why tsql shows TDS version as 5.0 rather than 8.0 as freetds.conf shows?

Is the default version used if not specified in configuration. Is useful
for example to use --with-tdsver=8.0 if you have all mssql 2000 or
above.

> 2. I did not specify any parameters for ./configure when freeTDS was
> built.   tsql shows 'no' for unixodbc currently.  Any way to let freetds
> use unixodbc instead of iodbc?  Where does FreeTDS look for unixodbc in
> the building process?  I'm wondering what prevented freeTDS from finding
> unixodbc.
> 

configure script try to detect installed version. It require
unixODBC/iODBC headers installed (ie unixODBC-devel package on redhat
and suse). It try to find installed unixODBC in standard position
(/usr, /usr/local). If you want to force a given DM you have to add some
argument to configure, refer to userguide (like
http://www.freetds.org/userguide/config.htm) for more details.

> $ tsql -C
> Compile-time settings (established with the "configure" script):
>                            Version: freetds v0.63
>     MS db-lib source compatibility: no
>        Sybase binary compatibility: unknown
>                      Thread safety: yes
>                      iconv library: yes
>                        TDS version: 5.0
>                              iODBC: yes
>                           unixodbc: no
> 
> /usr/local/etc/freetds.conf:
> 
> [global]
>         # TDS protocol version
>         tds version = 4.2
>         text size = 64512
> [MyServer2k]
>         host = ntmachine.domain.com
>         host = engrtest1.eng.iastate.edu
>         port = 1433
>         tds version = 8.0
> 
> Thanks in advance for any help,
> 
> Bing

freddy77