Pypyodbc: Can't open lib 'FreeTDS' : file not found") error when trying to connect to SQL server

python sql-server macos freetds pypyodbc
Mo. picture Mo. · Feb 17, 2015 · Viewed 22.9k times · Source

I'm trying to connect to a SQL Server using Pypyodbc on Mac and I'm getting the following error:

pypyodbc.DatabaseError: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'FreeTDS' : file not found")

I have installed freeTDS and unixodbc

brew install unixodbc
brew install freetds

and here is my connection String with dummy data: 

connection_String = "Driver=FreeTDS;Server=123.12.12.12;tds_version=7.2;Database=db_db;Uid=username:pwd=password:port=1433"

Answer

KtmDan picture KtmDan · Feb 10, 2016

Check your /etc/odbcinst.ini or it could be under /etc/unixODBC/odbcinst.ini

In your connection string you have something like this "DRIVER=FreeTDS" there needs to be an entry in that file like the following. You may need to change your driver location.

[FreeTDS]
Description             = FreeTDS unixODBC Driver
Driver          = /usr/lib64/libtdsodbc.so.0
Setup           = /usr/lib64/libtdsodbc.so.0
UsageCount              = 1

Related questions

SQL Server, Python, and OS X

What's a good way to interface Python running on OS X with a cloud-based SQL Server database? EDIT: With pyodbc I'm getting this error: >>> import pyodbc >>> cnxn = pyodbc.connect('DRIVER={SQL Server};SERVER=adsf.…

Read More
Retrieving Data from SQL Using pyodbc

I am trying to retrieve data from an SQL server using pyodbc and print it in a table using Python. However, I can only seem to retrieve the column name and the data type and stuff like that, not the …

Read More
Connecting to SQL Server 2012 using sqlalchemy and pyodbc

I'm trying to connect to a SQL Server 2012 database using SQLAlchemy (with pyodbc) on Python 3.3 (Windows 7-64-bit). I am able to connect using straight pyodbc but have been unsuccessful at connecting using SQLAlchemy. I have dsn file setup for …

Read More