Odbcinst -u -d -n "ODBC Driver 17 for SQL Server" Odbcinst.ini after the formula is uninstalled. If you installed this formula with the registration option (default), you'll => odbcinst -u -d -n "ODBC Driver 17 for SQL Server" You indicate that you accept the license terms.ĭo you accept the license terms? (Enter YES or NO) usr/local/share/doc/msodbcsql17/LICENSE.txt. The license terms for this product can be downloaded from => Installing msodbcsql17 from microsoft/mssql-releaseĪlready downloaded: /Users/erik/Library/Caches/Homebrew/downloads/b8402326ee28ebb9b25b5c98a4fcfe0ecad17cd385a8ccb3ef5bedb0e097c2e0-msodbcsql-17.5.2.1.tar.gz Is there extra magic in installing SQL Server drivers on a Mac OS ~ % brew install msodbcsql17 mssql-tools Sql_conn_irs = nnect('DRIVER= SERVER= DATABASE=irs UID=xxxx PWD=xxxxx ')ġ2 query = "SELECT * FROM Table_Curve order by Date asc"ġ3 dfirs = pd.read_sql(query, sql_conn_irs)Įrror: ('01000', " Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)") In order to execute this python code on a MAC, import pyodbc as odbc
0 Comments
Leave a Reply. |