Welcome to the django-pyodbc wiki!Below are instructions for setting up a Mac to connect to a MS SQL Server database.SummaryI'm using a Mac on Yosemite Version 10.10.1 trying to connect to a MS SQL Server database. I searched and couldn't find an updated detailed answer so here's a writeup that is mostly from this amazing article. I'm adding it on stackoverflow in case the link dies.

The Simba Microsoft SQL Server ODBC Driver is ODBC 3.8 data-standard compliant, and includes important functionality like support for OSX and 32- and 64-bit capability for high-performance cloud-computing environments. Product Highlights. Offers direct SQL BI connectivity to SQL Server data via the ODBC API, with no extraction needed.

The idea is that we'll have the following layers to setup/connect.Layers. PART 1 - pyodbc. PART 2 - freeTDS (can check with tsql). PART 3 - unixODBC (can check with isql). PART 4 - MS SQL (can check with a regular python program)Steps.Install Homebrew from - this is a package manager for Mac OSX. The article shows how to use another package manager 'MacPorts'. Apple 678 1361a dvdrw pd112 678t0278 super drive for mac pro. For my instructions, they're with homebrew.

Basically homebrew has a folder 'cellar' that holds different versions of packages. Instead of modifying your normal files, it instead points to these homebrew packages.We need to install Pyodbc: pip install pyodbc.Install FreeTDS with brew install freetds -with-unixodbc (FreeTDS is the driver that sits between the Mac ODBC and MS SQL Server, chart here shows which version of TDS you should be using based on your specific Microsoft Server version; e.g. Windows 7 professional 64 bit. Tds protocol 7.2 for Microsoft SQL Server 2008).Configure freetds.conf file (The file should be in '/usr/local/etc/freetds.conf', which for Homebrew is a link to say '/usr/local/Cellar/freetds/0.912/etc', but yours might be somewhere different depending on version).