Pyodbc installation error - symbol not found in flat namespace '_SQLAllocHandle'

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/, 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.

I can reproduce the error.

Maybe you have to install a database client for pyodbc to work?

I suggest you report the problem to the maintainers who are at (I found this from the PyPI page for pyodbc).