![]() Replace “ ODBC Driver 13 for SQL Server” with the content you copied in the square brackets. You need the copy the content in the square brackets which in my case is “ODBC Driver 13 for SQL Server”.Įxit the editor and open a new file like this: nano ~/tempfileĪdd the following lines to this file: ![]() ![]() There you will see the following information: ĭescription=Microsoft ODBC Driver 13 for SQL Serverĭriver=/usr/local/lib/libmsodbcsql.13.dylib Open odbc.ini using the following command: nano odbcinst.ini Now navigate to unixodbc folder using the following command: cd /usr/local/Cellar/unixodbc/2.3.4 Now you have all the prerequisites to connect to your MS SQL database in python. Next item you need to install is pyodbc by entering the following command in a terminal: pip install pyodbc The first thing you need is to install Homebrew.Įnter the following command in a terminal window to install Homebrew: /usr/bin/ruby -e "$(curl -fsSL )"Īfterward, enter the following commands in a terminal window to install Microsoft ODBC driver 13 for macOS: brew tap microsoft/msodbcsql Here is a quick and easy guide to connecting to your MS SQL using python. Microsoft has released a beta version of its ODBC driver for macOS. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |