I've also tried to explicitly give the driver file path to pyodbc in the connection string but then nnect() just hangs instead of aborting right away. ![]() ![]() USER DATA SOURCES.: /Users/kdot/.odbc.iniĪnd the odbcinst.ini file contains: ĭescription=Microsoft ODBC Driver 17 for SQL Serverĭriver=/opt/homebrew/lib/libmsodbcsql.17.dylib SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.iniįILE DATA SOURCES.: /opt/homebrew/etc/ODBCDataSources Here is the output when I run odbcinst -j: unixODBC 2.3.9ĭRIVERS.: /opt/homebrew/etc/odbcinst.ini So it seems like pyodbc cannot find the drivers I installed earlier. When I run pyodbc.drivers() I get an empty list. I then pip installed pyodbc but when I try to run nnect() within a test script, python just aborts with the following message, regardless which connection string I use:Īfter investigating a bit more I find that pyodbc doesn't have any drivers. ![]() So far I have installed unixodbc via homebrew and ODBC drivers according to the instructions found here: I have a new M1 pro macbook and I'm trying to install pyodbc and relevant drivers on my machine.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |