freeTDS: Missing libtdsodbc.so file on OSX?

Question

I am trying to connect to a SQL server from a python script on a Mac OSX and after installing freeTDS using brew install freeTDS I can't seem to find the driver "libtdsodbc.so" anywhere on my machine so that I can place it in the connection string.

Has anyone ever encountered this problem or knows why it's happening?

Thanks

Answer 1

So according to This thread here the issue is with the way freeTDS is built now, you need to use brew install freetds --with-unixodbc and I can verify this fixed my problem.