Fix pyodbc.Error: (‘01000’, “[01000] [unixODBC][Driver Manager]Can’t open lib ‘ODBC Driver 13 for SQL Server’ : file not found (0) (SQLDriverConnect)”)
I was connecting from my macbook to a SQL Azure Database when i hit the following error:
>>> environ.get('cloud_sql_conn_string') 'Driver={ODBC Driver 13 for SQL Server};Server=tcp:cynexia-sql.database.windows.net,1433;Database=cloud_scales;Uid=<username>;Pwd=<password;Encrypt=yes;TrustServerCertificate=no;Connection Timeout=30;Authentication=ActiveDirectoryPassword' >>> import pyodbc >>> cnxn = pyodbc.connect(environ.get('cloud_sql_conn_string')) Traceback (most recent call last): File "<stdin>", line 1, in <module> pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 13 for SQL Server' : file not found (0) (SQLDriverConnect)")
The solution was to install the ODBC driver, following the instructions on the Microsoft website:
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release brew update HOMEBREW_NO_ENV_FILTERING=1 ACCEPT_EULA=Y brew install msodbcsql17 mssql-tools ACCEPT_EULA=Y brew install [email protected] [email protected]