5

I am working in python. I am using Macbook for development and OS version is Catalina. I am trying to connect MSSQL Server with pyodbc. I installed SQL Drivers and its dependencies as well. But while connecting I am getting this error.

Exception -  ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found (0) (SQLDriverConnect)")

I Checked the file path '/usr/local/lib/libmsodbcsql.13.dylib'. Actually file is available there. Can anyone help me?

karthik
  • 283
  • 2
  • 15

1 Answers1

3

Solution: For 13 version need open ssl v 1.0.0 , you can try it.

brew install https://github.com/tebelorg/Tump/releases/download/v1.0.0/openssl.rb

Mihail Kuznetsov
  • 323
  • 5
  • 22
  • 1
    The above won't work: https://github.com/Homebrew/homebrew-core/issues/47348 My recommendation is to use the v17 driver and if you MUST use v13 then to install openssl v1: https://github.com/Homebrew/homebrew-core/issues/47348#issuecomment-560001981 – Pouya Barrach-Yousefi Sep 17 '20 at 10:24