I can connect RStudio to Athena via JDBC, but when I try to use an ODBC driver I get the error message:
Error: nanodbc/nanodbc.cpp:1021: 00000: [Simba][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.
I have searched for this error online and tried the solutions (e.g., ensuring I have only one odbc.ini and one odbcinst.ini file on my Mac). but the error persists? I know that my credentials are valid because I can connect via JDBC, but I'd like to take full advantage of ODBC perks in RStudio. How can I resolve this error?