How to import pyodbc on macbook with m2 chip?

Python Help
1

Hi all,
If I work on windows PC I have no problem to import and use pyodbc, BUT when I tried it on my MacBook with M2 chip it doesnt work … so … how to import pyodbc (to connect to sql server database) on my macbook with m2 chip?

Thanks a lot

2

You need to provide some more detail. What error do you get when importing it? Are you sure it’s installed? A full traceback would also be helpful.

3

Hi,

  1. yes, I am sure I installed it:
    pyp3 install pyodbc
    and then just put this code …
import pyodbc
print("Hello worlds")

ERROR:
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'
4

Ahhh… Try following the clues here:

Looks like you are missing some underlying libraries.

5

Thanks, seems that helped … no I am trying to connect to sql server database but I shows me an error:
pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

my code:

drivers = pyodbc.drivers()
for d in drivers:
    print(d)
conn = pyodbc.connect('DRIVER={ODBC Driver 18 for SQL Server}; \
                    Server=SERVER-NAME; \
                    Database=DTB-NME; \
                    User ID=USERNAME; \
                    Password=PASS')

cursor = conn.cursor()
cursor.execute('SELECT name FROM cars')
for i in cursor:
    print(i)

what’s wrong? It

6

Can’t help with that. I haven’t really touch SQL since retiring a few years ago.