Been trying to work on a small python database program using pyodbc. I have already installed unixodbc using brew as well as done a pip install of pyodbc. The pip install seems to work fine (no errors).
However, a simple test of firing up the interpreter and trying
import pyodbc
yields the following error message
>>> import pyodbc
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
ImportError: dlopen(/Library/Frameworks/Python.framework/Versions/3.11/lib/python3.11/site-packages/pyodbc.cpython-311-darwin.so, 0x0002): symbol not found in flat namespace '_SQLAllocHandle'
Seen a couple of other sites reporting issues with a pyodbc on a Mac M1 (which I am using) but not been able to implement any of the suggested workarounds which seem to involve recompiling the pyodbc python files.
Not exactly a python expert so any help would be appreciated.