dyld: Library not loaded: /usr/local/opt/unixodbc/lib/libodbc.2.dylib
In addition to
brew install unixodbc
you can also install the mssql drivers after this with the following brew instructions:
brew tap microsoft/mssql-release https://github.com/Microsoft/homebrew-mssql-release
brew update
brew install msodbcsql mssql-tools
After this I was able to use "ODBC Driver 17 for SQL Server" in python.
Insalling unixodbc on Mac resolved this for me.
brew install unixodbc