Installing Pyodbc on a Mac

Install FreeTDS and UnixODBC

Install Homebrew

If homebrew is not installed, get that first.

/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
brew install unixodbc
brew install freetds

Configure TDS Connection Information

Edit the file /usr/local/etc/freetds.conf

nano /usr/local/etc/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 /usr/local/etc/odbcinst.ini

[FreeTDS]
Description=FreeTDS Driver for Linux & MSSQL
Driver=/usr/local/lib/libtdsodbc.so
Setup=/usr/local/lib/libtdsodbc.so
UsageCount=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

Last updated December 14,2019