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: https://do...
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...
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
Comments
Post a Comment