import pyodbc failure mac os

Question

I've tried to install pyodbc on mac, but I got this error

Traceback (most recent call last):
  File "Untitled.py", line 1, in <module>
    import pyodbc
ImportError: dlopen(/usr/local/lib/python3.6/site-packages/pyodbc.cpython-36m-darwin.so, 2): Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib
  Referenced from: /usr/local/lib/python3.6/site-packages/pyodbc.cpython-36m-darwin.so
  Reason: image not found

What could it be and how can I solve it?

score 34 · Accepted Answer · edited Oct 30 '19 at 10:54

34

See if an installation of unixodbc helps you:

brew install unixodbc

edited Oct 30 '19 at 10:54

jmd_dk

12,125
9
63
94

answered Dec 21 '18 at 15:15

rajiv

486
6
9

score 4 · Answer 2 · answered Feb 17 '23 at 17:34

4

I tried all of the above with no luck. Finally I installed version 4.0.34 of pyodbc along with the unixodbc and now all is well.

brew install unixodbc  
pip install pyodbc==4.0.34

answered Feb 17 '23 at 17:34

Paul Bennett

41
3

score 0 · Answer 3 · edited Dec 11 '20 at 19:43

0

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

Paste this command in MAC terminal if brew not found. after that - brew install unixodbc

edited Dec 11 '20 at 19:43

Dharman

30,962
25
85
135

answered Jul 18 '20 at 20:14

Puurusottam Saha

1
1

2

It would be great if you can expand your answer on "how" does this fix the issue. – yardstick17 Oct 23 '21 at 10:05

import pyodbc failure mac os

3 Answers3