MacOS Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : OpenSSL library could not be loaded

使用 brew 安装了 mssql-tools 后，用 sqlcmd 连接 SQL Server 2014 执行 SQL 脚本出现如下报错：

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed].
Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Client unable to establish connection.

解决方法:
将软链接 /usr/local/opt/openssl 的源文件从 openssl@3.0 换成 openssl@1.1.

brew install openssl@1.1
ls -l /usr/local/opt/openssl
cd /usr/local/opt/
rm -f openssl
ln -s ../Cellar/openssl\@1.1/1.1.1o openssl

这篇好文章是转载于：学新通技术网