The provider is not compatible with the version of Oracle client

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

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.