Ubuntu – Where to find MSSQL ODBC driver .so file


  • Ubuntu 14.04.1 LTS

From my Ubuntu machine I want to access an MS SQL 2005 server via ODBC. This MSSQL server is on our internal network. I've installed these packages: unixodbc, unixodbc-dev, unixodbc-bin, libodbc1, libtool, autotools-dev and several other dependencies. Also tdsodbc, freetds-bin, freetds-common, freetds-dev, libct4.

But I can't seem to find where the .so file is to use it in my DSN in /etc/odbc.ini. Which file do I use? Doing this: echo "select 1"|isql -v mydsn gives me this error:

[01000][unixODBC][Driver Manager]Can't open lib '/usr/lib/libtdsodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect

The 'mydsn' is trying to point to /usr/lib/libtdsodbc.so but it's not there. Which .so file do I set up in the /etc/odbc.ini file?

Thank you.

Best Answer

According to this link: http://www.unixodbc.org/doc/FreeTDS.html, it might be:


Another possibility is:


This is for 64-bits architecture.

Once you found the right place, update the /etc/odbcinst.ini to reflect the changes.