[freetds] how to enable unixodbc after building freeTDS?

Bing Du bdu at iastate.edu
Tue Nov 15 10:16:45 EST 2005


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?
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.

$ 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



More information about the FreeTDS mailing list