Skip to Content.
Sympa Menu

freetds - Re: [freetds] how to enable unixodbc after building freeTDS?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] how to enable unixodbc after building freeTDS?
  • Date: Tue, 15 Nov 2005 16:36:09 +0100

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






Archive powered by MHonArc 2.6.24.

Top of Page