Related: https://forum.posit.co/t/cant-open-lib-opt-homebrew-lib-libmsodbcsql-17-dylib-from-m1-mac-arm64/122205
Installing R and Rstudio worked for me when trying to connect to ODBC Driver 17 for SQL Server. However, it does not allow rJava to successfully build and I reinstalled R from https://mac.r-project.org/. rJava now works but odbc does not.
Is there a way to install the version from mac.r-project via homebrew?