My understanding is that the value of at the time libsqora.dylib.12.1 is loaded will determine whether these libraries can be found. It turns that that the Oracle ODBC driver does use here is the (partial) output from otool -l libsqora.dylib.12.1: Load command 3

This seems to matter for run-path dependent libraries. The main clue from from the 'Understanding R's Startup' article linked above, where mentions that RStudio 'doesn’t 'start' R, it uses R as a library, either as a DLL on Windows or as a shared object on Mac and Linux.' This is intriguing, because it suggests that there may be different binaries involved for each environment. I posted a version of this question on the Oracle Community forums as well, but so far haven't had any replies. So, I am guessing that the issues (rendering RMD, launching R from the CLI) are related. I should note that this problem also seems to affect rendering R Markdown inside RStudio, e.g., an RMD that contains the dbConnect() statement will render, and the rendered document will show the 'file not found' error. I haven't included a reprex because this seems like such an in-the-Mac-weeds problem that I am not even sure what information would be helpful. In particular, I (unsuccessfully) tried manually setting the path, i.e., Sys.setenv(DYLD_FALLBACK_LIBRARY_PATH = '/usr/local/lib') I've read through this article on the startup differences, but nothing I tweak in R seems to work. differences in how RStudio launches R versus launching R at the command line.the DYLD_FALLBACK_LIBRARY_PATH environment variable.I think this has something to do with one or more of the following, but I haven't had much luck tracking it down. Now, the file exists at /usr/local/Cellar/instantclient-basic/12.2.0.1.0-2/lib and is symlinked into /usr/local/lib.

When I attempt the same from R, I get an error: Error: nanodbc/nanodbc.cpp:950: 01000: Can't open lib '/usr/local/lib/libsqora.dylib.12.1' : file not found I have installed Oracle Instant Client, including the ODBC package, configured a DSN, and can connect within RStudio, i.e., the following works: conn <- DBI::dbConnect( I am attempting to connect to Oracle Database using the odbc package on macOS High Sierra.

Oracle client for mac sierra