11

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

Mo.
  • 40,243
  • 37
  • 86
  • 131
  • Check out https://github.com/Homebrew/homebrew/issues/24550 for people with similar issues. There's more than one "fix" floated there. – AlG Jan 21 '15 at 19:10
  • yeah I found that a couple of mins after posting the question. I'll put the fix as an answer for anyone else who has the problem and reference the source. – Mo. Jan 21 '15 at 19:28

1 Answers1

18

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.

Mo.
  • 40,243
  • 37
  • 86
  • 131