I was getting the following weird error when running pyodbc on my Mac and trying to connect to my Windows Database:
OperationalError: ('08001', ' [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)')
Using the wonderful powers of Google I came across this article:
Following the information from JH88:
brew install firstname.lastname@example.org # you might need to delete the old symlink first # rm /usr/local/opt/openssl ln -s /usr/local/Cellaremail@example.com/1.1.1l /usr/local/opt/openssl
I still wasn’t getting it to work, turns out Brew had installed version 1.1.1l_1 on my machine so I needed to do the following:
ln -s /usr/local/Cellarfirstname.lastname@example.org/1.1.1l_1 /usr/local/opt/openssl
After that quick fix everything started working correctly again.
Thanks for sharing the solution. After going through various github threads finally, this one worked.