ODBC Driver Issues using Presto ODBC Drivers on Mac OS

Posit Professional & Hosted Products
8

Alright, here is a brief update.
I still get this error:

Failure. nanodbc/nanodbc.cpp:950 HY000: [Simba] [ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.

However, I only get it when I connect using an .odbc.ini file where I have my connection string written out.

To elaborate, here is my .odbc.ini file:

[ODBC Data Sources]
connection1=[Simba SQL Server ODBC Driver]

[connection1]
Driver=/Library/simba/sqlserverodbc/lib/libsqlserverodbc_sbu.dylib
Server=myserver
Database=mydb
UID=mylogin
PWD=mypassword
Trusted_Connection=NTLM

This connection fails:

con <- dbConnect(odbc::odbc(), "connection1")

(it used to work in the past. connection1 is still found in the list of available connections, as it is found via .odbc.ini file)

But this connection succeeds:

con2 <- dbConnect(odbc::odbc(), .connection_string = "Driver={Simba SQL Server ODBC Driver};
                 Server={myserver};
                 Database=mydb;
                 UID=mylogin;
                 PWD=mypassword;
                 Integrated Security=NTLM")

Any hunch on why is this?