Python Module Installation Issues and Work Arrounds

Problem: 

When Running PYODBC in Mac , User getting Error "pyodbc.OperationalError: ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection (0) (SQLDriverConnect)')" 

Solution: 

Run the following commands

rm -rf /usr/local/opt/openssl

version=$(ls /usr/local/Cellar/openssl@1.1 | grep "1.1")

ln -s /usr/local/Cellar/openssl@1.1/$version /usr/local/opt/openssl

Source: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/known-issues-in-this-version-of-the-driver?view=sql-server-ver15