[freetds] Re: RE: freeTDS unixODBC...Which one isn't working

James K. Lowden jklowden at schemamania.org
Mon Jan 5 01:15:58 EST 2004


On Tue, 30 Dec 2003, "Daughterson, Adam [EPM/BOU/MMI]"
<Adam.Daughterson1 at EmersonProcess.com> wrote:
> 
> Something is not right.  Did you install FreeTDS in
> 
> 	/usr/local
> or	/usr/local/freetds
> 
> I specified /usr/local/freetds with the --prefix option. (This was the
> path in the earlier documentation, so for the sake of clarity, I put it
> there...)

OK, that means your libraries will be in /usr/local/freetds/lib and your
freetds.conf and odbc.ini (for FreeTDS, AIUI) will be in
/usr/local/freetds/etc.  That is, you would describe any FreeTDS Data
Source Names in /usr/local/freetds/odbc.ini.  

> root at USBOU1-DHDLINUX:~# ldd `command -v isql`
>         libodbc.so.1 => /usr/local/lib/libodbc.so.1 (0x40016000)
>         libodbcinst.so.1 => /usr/local/lib/libodbcinst.so.1 (0x40075000)
>         libdl.so.2 => /lib/libdl.so.2 (0x40097000)
>         libreadline.so.4 => /usr/lib/libreadline.so.4 (0x4009a000)
>         libncurses.so.5 => /lib/libncurses.so.5 (0x400c6000)
>         libpthread.so.0 => /lib/libpthread.so.0 (0x40102000)
>         libc.so.6 => /lib/libc.so.6 (0x40153000)
>         /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
> root at USBOU1-DHDLINUX:~#
> 
> I changed /usr/local/etc/odbc.ini and ~/odbc.ini to reflect the driver
> being

I *think* your odbc.ini has to be in PREFIX/etc.  For sure, the FreeTDS
ODBC driver will look there.  I guess your odbcinst.ini (?) will somehow
tell your DM where to find it.  

> libodbc.so.1 (from ldd above) instead of libtdsodbc.so (which one's
> which? Ah, future question I guess...) 

libtdsodbc is provided by FreeTDS.  libodbc is perhaps provided by the
driver manager?  

--jkl


More information about the FreeTDS mailing list