- 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:
[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?