Connecting to Oracle DB with odbc library fails on macOS Catalina

nickodemus · August 4, 2020, 2:29am

Hi @yateam. I have gotten a response from @alexkgold in this thread.

Connecting to Oracle DB with odbc library fails on macOS 10.15.5 General

Hi @nickodemus, It looks to me like odbcinst -j is returning the correct output, and you are able to successfully run isql, so I think you're almost there. For some reason, your R code isn't actually making use of the DSN you're configuring, and therefore R is looking in the wrong place for the driver. Can you share the isql command that's running successfully? That might be a hint here. It looks like you've got a few different pieces configured here, but the simplest pattern is usually to: Define the DSN in odbc.ini with a name. In this case, it looks like you've defined a DSN named banner in the odbc.ini. Use that DSN in your DBI code. Since your DSN is named banner, your DBI code wou…

Sorry that there are two threads. I switched the category on my thread and it opened a new one.