working on Windows Server 2008R2 64-bit, installing ruby 1.8.7, ruby-oci8 ran into the following error, after requiring ‘oci8’ : LoadError 193: %1 is not a valid Win32 application

On this machine a 64bit version of Oracle was installed. So the OCI.dll was a 64-bit version. The fix seemed easy: copy a 32-bit version of the OCI.dll.

But I had to copy (from another 32-bit machine)

  • OCI.dll (32-bit)
  • MSVCR71.dll
  • … and ORAOCIEI10.dll
    to my ruby\bin folder, and then everything worked.

    Copying just the OCI.dll and MSVCR71.dll gave the puzzling error OCIError: OCI library initialization error.