All Tips

Installing Pyodbc on Ubuntu Server - Oracle Database

databasemssqlpyodbcubuntu
👋 Thanks for reading! Things have changed since this was written, take it with a grain of salt ;)

∞ Install FreeTDS and UnixODBC

sudo apt-get install unixodbc unixodbc-dev freetds-dev tdsodbc freetds-bin

∞ Configure TDS Connection Information

Edit the file /etc/freetds/freetds.conf

nano /etc/freetds/freetds.conf

Add your connection information to the end.

[<connection_name>]
host = <hostname>
port = <port>
tds version = 7.0

Test the new connection with

tsql -S <connection_name> -U <username> -P <password>

∞ Add TDS Connection info to the ODBC driver list

Run odbcinst -j to find the file directories for odbcinst.ini and odbc.ini

Update odbcinst.ini to include the info below.

odbcinst -j

# get path from results of odbcinst -j
nano /etc/odbcinst.ini

[FreeTDS]
Description=FreeTDS Driver for Linux & MSSQL
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
CPTimeout =
CPREuse =
FileUsage = 1

# control x to save

Next, edit the odbc.ini file.

Add the following info.

odbcinst -j

# get path from results of odbcinst -j
nano /usr/local/etc/odbc.ini

[<connection_name>]
Description         = <connection_description>
Driver              = FreeTDS
Servername          = <connection_name>

# note: FreeTDS must match the name given in odbcinst.ini

∞ Install pyodbc

Finally, pyodbc for python can be installed

pip install pyodbc
location