I'm running macOS High Sierra (10.13.4) and am attempting to connect to Oracle Database using the R odbc package. I'm using Instant Client 12.2.0.1.0 and began by following the instructions here:
https://blogs.oracle.com/opal/installing-the-oracle-odbc-driver-on-macos?dd
I followed these instructions with the exception of the version of unixODBC. I installed the latest version (2.3.6) using homebrew. This got me to the point of being able to connect to the database using isql. The next step was to install the ROracle package. I ran into issues here as well, but eventually resolved them by following the answer here using install_name_tool:
https://stackoverflow.com/questions/47821311/installing-roracle-and-the-oracle-instant-client-on-macos
So, the next step is to attempt to connect with the odbc package. The following statements throw an error:
> library(odbc)
> dbConnect(odbc::odbc(), dsn="mydsn")
Error: nanodbc/nanodbc.cpp:950: 01000: [unixODBC][Driver Manager]Can't open lib '/path/to/instantclient_12_2/libsqora.dylib.12.1' : file not found
Now, libsqora.dylib.12.1 exists at the indicated path. This seems like another path issue. Any thoughts?