4

I've installed mssql-tools and msodbcsql,

And I've symlinked /usr/local/homebrew/lib/libmsodbcsql.13.dylib to /usr/local/lib/libmsodbcsql.13.dylib

But sqlcmd still complains about missing lib,

%> sqlcmd -S IP
Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Can't open lib '/usr/local/lib/libmsodbcsql.13.dylib' : file not found.

Any ideas?

kenorb
  • 20,250
  • 14
  • 140
  • 164
daisy
  • 53,527
  • 78
  • 236
  • 383

5 Answers5

3

As @thrig says, I tried to dtruss to debug the problem,

sudo dtruss sqlcmd -S someserver

And from the output, sqlcmd attempts to read /usr/local/lib/libodbcinst.2.dylib and failed.

Adding symlink of libodbcinst.2.dylib solved the problem, so it's actually caused by a missing dependency, sigh

daisy
  • 53,527
  • 78
  • 236
  • 383
2

This doesn't happen on all our machines, but we did run into it today. We ran

brew install msodbcsql

We encountered

libmsodbcsql13.dylib not found

We ran

brew link msodbcsql

This resulted in:

4 symlinks created

This fixed the issue for us.

Radio
  • 121
  • 4
1

Solution

First of all try reinstalling the packages again:

brew tap microsoft/msodbcsql https://github.com/Microsoft/homebrew-mssql-release
ACCEPT_EULA=y brew reinstall --no-sandbox msodbcsql mssql-tools

Then if it's still happening, run:

cp -v "$(brew list msodbcsql | grep odbcinst.ini$)" ~/.odbcinst.ini

to copy the INI file which defines the location of SQL ODBC driver.

Bug report: SQL Server : Can't open lib 'ODBC Driver 13 for SQL Server'.

Then test your SQL setup by: sqlcmd -S localhost or isql -v -k <connection-string>.

See: Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS.

Debugging

$ odbcinst -j # Verify the config.
$ sleep 20 && sqlcmd -S localhost & # Run `sqlcmd` in the background.
$ sudo fs_usage -f filesys | grep -w sqlcmd | grep -e open -e access -e stat64
open              /Users/myuser/.odbcinst.ini                 
access            /usr/local/lib/ODBC Driver 13 for SQL Server
access            /lib>>>>>>>>>>>>>>>>>>>>                    
access            /usr/lib/ODBC Driver 13 for SQL Server      
stat64            ODBC Driver 13 for SQL Server               
stat64            /opt/X11/lib/ODBC Driver 13 for SQL Server  
stat64            /usr/lib/ODBC Driver 13 for SQL Server

For Linux, see this Anaconda related issue: ODBC Driver 13 for SQL Server can't open lib.

kenorb
  • 20,250
  • 14
  • 140
  • 164
0

I ran into the same problem and the dtruss trace produced the same output as described by daisy.

The location of the missing lib is with the unixodbc drivers. You can install those with brew install unixodbc if you don't have them. The link command and paths required for linking on my system were as follows:

ln /usr/local/Cellar/unixodbc/2.3.6/lib/libodbcinst.2.dylib /usr/local/lib/libodbcinst.2.dylib

Obviously, you may have a different version, but it should be located beneath the path /usr/local/Cellar/unixodbc

After adding this link, I am able to connect to my local and remote SQL servers from the terminal. I'm on macOS High Sierra 10.13.5.

Shanerk
  • 101
  • 2
-1

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

Ontnanda
  • 1