The provider is not compatible with the version of Oracle client

Posted by Blake on 1/18/2012
)

Nothing with Oracle is light weight, or straight forward.

The above error occurs whenever you don’t have the appropriate DLL’s with your project in the path. For me, my ASP.NET site worked on my local workstation because I had the ODAC installed, but not on the server. The solution is to download the large XCOPY distributable from Oracle and pull out the DLL’s you need. The oraociei11.dll is 127MB itself (yikes). Oracle may run very well, but it does nothing light weight. Checking that into my source control makes me cringe a little.

Anyway, this link helped me get started, I’ll also provide the DLL list that I used in my Bin directory:

  1. oci.dll
  2. ociw32.dll
  3. Oracle.DataAcess.dll
  4. orannzsbb11.dll
  5. oraocci11.dll
  6. oraociei11.dll
  7. OraOps11w.dll
  8. orasql11.dll