Installing Microsoft ODBC Driver to connect to SQL from Python on Mac OS X

What a nightmare it's been for me to figure this out.

Remember to have homebrew installed in advance.

Then run this in terminal:

brew install msodbcsql
At first, it didn't work for me, saying something about taps was empty and no available formulas.

Then I found out I needed to run this command in Terminal

rm -rf /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core; brew update

Then I could run brew install msodbcsql ... but not successfully.

OK, so I tried another approach

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

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update 

brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release

followed by...

 brew install msodbcsql17 mssql-tools

This seems to have worked! My driver is now ODBC Driver 17 for SQL Server

Ressources:

Comments

Post a Comment

Popular posts from this blog

Connection to MSSQL with Pythonan and pyodbc (on Mac OS X)

There are many python SQL drivers available. Microsoft however places its efforts and confidence in pyodbc driver. If the library pyodbc is not installed, do the following Open Terminal Run this command: pip3 install pyodbc The following will be the result brians-air:~ imac$ pip3 install pyodbc Collecting pyodbc   Downloading https://files.pythonhosted.org/packages/92/91/c0c473491b49a5492f911b745d1388da9c60dd152a93841dc90cf21d0e97/pyodbc-4.0.27-cp37-cp37m-macosx_10_9_x86_64.whl (63kB)     100% |████████████████████████████████| 71kB 237kB/s   Installing collected packages: pyodbc Successfully installed pyodbc-4.0.27 You are using pip version 19.0.3, however version 19.2.3 is available. You should consider upgrading via the 'pip install --upgrade pip' command. It's now installed. But does it work? No... Not at first! At least not for me. That didn't work for me and when trying to import the library, this was the result. Input: im...
Read more

Installing PyCharm on Mac

I use PyCharm to edit, run and debug my Python code. It does not exist in the App Store. Instead, get it from  https://www.jetbrains.com/pycharm/ Get the community edition for learning. The installation is about 340 mb. Once it's installed go ahead and launch the application. Before you go ahead and create a new project, change the Python Interpreter from Virtualenv Environment to System Interpreter and select the latest version of Python (in my case it's Python3 that we have just installed) Tip: Skip to about 8 minutes in to this video for more info:  https://www.youtube.com/watch?v=oyzH4M6X6F4
Read more