Pypyodbc: Can't open lib 'FreeTDS' : file not found") error when trying to connect to SQL server
freetds, macos, pypyodbc, python, sql-server
Solution
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
Problem
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" ```