unixODBC Driver Manager Can't open lib

Asked Nov 21 '16 at 21:19

Active Nov 21 '16 at 21:27

Viewed 4,435 times

I'm trying to connect to SQL Server db using django 1.10 and pyodbc, Mas Os X 10.11.5

Firstly, when I'm typing

python manage.py inspectdb

the traceback is

('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' file not found (0) (SQLDriverConnect)")

So I've installed

brew install freetds

so my /usr/local/lib/

contains

libct.4.dylib       libct.dylib     libodbc.dylib       libodbccr.dylib     libodbcinst.dylib   libsybdb.a
libct.a         libodbc.2.dylib     libodbccr.2.dylib   libodbcinst.2.dylib libsybdb.5.dylib    libsybdb.dylib

but error message is still the same

('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' file not found (0) (SQLDriverConnect)")

The question is what should I write in odbcinst.ini? Am I doing it the right way?

edited Nov 21 '16 at 21:27

asked Nov 21 '16 at 21:19

insomniaqq

does it still throw the error after installing the library? – matias elgart Nov 21 '16 at 21:21
i used this post to configure pyodbc http://www.tivix.com/blog/getting-django-working-with-mssql-pyodbc/ – Zagorodniy Olexiy Nov 21 '16 at 21:25
@ZagorodniyOlexiy Can you please answer the question with the solution? The link is broken. – Clint Nov 06 '17 at 16:01

unixODBC Driver Manager Can't open lib

0 Answers0