我正试图让mssql在我的OSX机器上工作。然而,它一直给我错误:
$ sqlcmd -S 0.0.0.0,1401 -U SA -P P@55w0rd -i database-setup/sql/initialize.sql
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Can't open lib '/usr/local/lib/libmsodbcsql.17.dylib' : file not found.
虽然,我很确定,我的文件在那个位置:
$ ls -la /usr/local/lib/libmsodbcsql.17.dylib
lrwxr-xr-x 1 localadmin admin 64 7 4 16:38 /usr/local/lib/libmsodbcsql.17.dylib -> /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
$ ls -la /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
-r--r--r-- 1 localadmin admin 2539360 7 4 15:34 /usr/local/Cellar/msodbcsql17/17.1.0.1/lib/libmsodbcsql.17.dylib
我知道这个问题已经被问了很多次,但没有一个可用的解决方案对我有效。我尝试过的东西:
- https://github.com/Microsoft/homebrew-mssql-release/issues/7
- https://github.com/Microsoft/homebrew-mssql-release/issues/3
我通过以下方式解决了问题:
$ brew uninstall msodbcsql17 mssql-tools
然后:
$ brew install msodbcsql17 mssql-tools
对我来说,这解决了它:
brew install microsoft/mssql-release/msodbcsql17