FreeTDS: config.c:461: ignoring unrecognized

[Louis Pieterse]

Hi,

I get this error message when trying to use FreeTDS from within pymssql (python module)
FreeTDS: config.c:461: ignoring unrecognized option 'instance'

System:
Ubuntu 8.04
FreeTDS v0.82 compiled with ./configure --with-tdsver=8.0 --enable-msdblib
pymssql 0.8.0

config file /etc/freetds/freetds.conf looks like this
[global]
        tds version     = 8.0

[za0204lsrv0011f]
        host            = 10.2.4.167
        instance        = BKUPEXEC
        port            = 1433
        tds version     = 8.0

Does anybody know what could causing this and how I can fix it ?

Thanks in advance
Louis

[Louis Pieterse]

Hi All,

It seems libsybdb5 had been installed from the Ubuntu repositories as a dependency of something else before I installed freetds.
pymssql picked up these libraries and used them instead instead of the freetds supplied ones.

after running the following commands all is well..
mkdir /etc/freetds
ln -s /usr/local/etc/freetds.conf /etc/freetds/ freetds.conf
rm /usr/lib/libsybdb.so.5*
ln -s /usr/local/lib/libsybdb.so.5.0.0 /usr/lib/libsybdb.so.5
ln -s /usr/local/lib/libsybdb.so.5.0.0 /usr/lib/libsybdb.so.5.0.0

*************************************************************************
Now I can connect to a MSSQL named instance using NT authentication from my linux box and life... is awesome

Thank you for this great software :)

*************************************************************************