[Python code sample] (sample_python_mac.py) that runs on a Mac computer. The sample and connects to Azure SQL Database by using the pymssql driver.
Open your terminal and install
1) Homebrew: Run the following command from your terminal. This will download the Homebrew package manager on your machine.
ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
2) FreeTDS: Run the following command from your terminal. This will download FreeTDS on your machine. FreeTDS is required for pymmsql to work.
brew install FreeTDS
3) Pymmsql: Run the following command from your terminal. This will install pymmsql on your machine.
sudo -H pip install pymssql
See the getting started page to learn how to create a sample database and get your connection string. It is important you follow the guide to create an AdventureWorks database template. The samples shown below only work with the AdventureWorks schema.