I used to have the connections working fine but things updated and now I cannot connect to a networked SQL Server. I am able to connect using MS Azure but Rstudio will not connect. I have the drivers installed. In my odbcinst.ini I see the driver listed
[ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/usr/local/lib/libmsodbcsql.17.dylib UsageCount=1
however when I run
odbc::odbcListDrivers() I get
 name attribute value <0 rows> (or 0-length row.names)
In a terminal window when I run
odbcinst -j. it displays the drivers in
I tried updating Renviron to include
ODBCSYSINI=/etc and also tried
ODBCSYSINI=/opt/homebrew/etc based on Solutions - Setting up ODBC Drivers to no avail. All steps I tried restarting my computer.
What else am I overlooking or how can I fix this? Thanks.