Installation for linux guys

1. Install a driver for your linux machine!
2. I recommend FreeTDS

Installing FreeTDS from bash script

You may look at my script @ https://github.com/adgsenpai/InstallFreeTDS (opens in a new tab)

Installing FreeTDS Manually

1. Install pre-requisite packages

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

2. Point odbcinst.ini to the driver in /etc/odbcinst.ini

[FreeTDS]
Description = v0.91 with protocol v7.2
Driver = MYDRIVERPATH

where MYDRIVERPATH is the path of the libtdsodbc.so file

Hint! Look in the /usr/lib/mylinuxdistro/odbc folder! Will implement script in the future to install/automate this for linux solutions.

pip install sqlserver

Installation for windows guys

pip install sqlserver