title: How to get MacOS Oracle ODBC client working with unixodbc?
body: <p>I'm having a difficult time getting the Oracle 12.2.0.1.0-2 ODBC drivers and Instant Client (Basic Lite version) working with homebrew-installed unixODBC 2.3.5 under MacOS 10.12.6 (Sierra). </p>
  
  <p>Extracting both of the Oracle ZIP files to <code>/opt/ora12/instantclient_12_2</code>, creating symlinks for <code>libclntsh.dylib</code> and <code>libclntsh.dylib.12.1</code>, then pointing odcb to the <code>/opt/ora/12/instantclient_12_2/libsqora.lib</code> gives  a file not found error. While the path definitely exists and has good permissions, inspecting the dylib with <code>otool -L</code> shows that the <code>@rpath</code> directories are not finding the supporting libraries.</p>
  
  <p>If I pull down the 12.2 sqlplus client, extract it to the same instantclient tree and run the binary, the CLI works fine. This seems to be some sort of dylib loading issue with odbc, but I'm not sure how to fix it. I've tried setting DYLIB_LIBRARY_PATH, copying all the libraries straight into <code>/usr/local/lib</code>, all to no effect.</p>
  
  <p>I've not yet tried to pull out <code>install_name_tool</code> and hard coding search paths (getting further in the weeds than I've done before on MacOS) and I'm hoping something so drastic and non-portable isn't required. Is there a step to the install process I'm missing to get this working?</p>
  
  <p>Thanks in advance!</p>