The provider is not compatible with the version of Oracle client

by

I’ve been looking into this problem further, and you simply need to grab all the appropriate DLL’s from the same downloaded version of ODP.Net and put them in the same folder as your Exe file, because ODP.Net is fussy about not mixing version numbers.

I’ve explained how to do this here: http://splinter.com.au/using-the-new-odpnet-to-access-oracle-from-c
Here’s the gist of it though:

  • Download ODP.Net
  • Unzip the file
  • Unzip all the JAR’s in it
  • Grab these dll’s that were just unzipped:
    • oci.dll (renamed from ‘oci.dll.dbl’)
    • Oracle.DataAccess.dll
    • oraociicus11.dll
    • OraOps11w.dll
    • orannzsbb11.dll
    • oraocci11.dll
    • ociw32.dll (renamed from ‘ociw32.dll.dbl’)
  • Put all the DLLs in the same folder as your C# Executable

More Related Contents:

  1. Sending an array of values to Oracle procedure to use in WHERE IN clause
  2. ODP.NET Managed library does resolve alias, but 32-bit library does
  3. How to get the URL of the current page in C# [duplicate]
  4. Difference between RegisterStartupScript and RegisterClientScriptBlock?
  5. How to set session timeout in web.config
  6. Unable to update the EntitySet – because it has a DefiningQuery and no element exist
  7. Why is HttpContext.Current null after await?
  8. How to work with time zones in ASP.NET?
  9. EPPlus number format
  10. IIS Server & ASP.Net Core – 500.19 with error code 0x8007000d on httpplatformhandler tag
  11. Can the Oracle managed driver use async/await properly?
  12. jQuery Ajax calls to web service seem to be synchronous
  13. Connection timeout for SQL server
  14. Does FileStreamResult close Stream?
  15. Display custom error page when file upload exceeds allowed size in ASP.NET MVC
  16. How DataReader works?
  17. ASP.NET GridView: How to edit and delete data records
  18. Convert IHtmlContent/TagBuilder to string in C#
  19. What is passing parameters to SQL and why do I need it?
  20. Calling async methods from non-async code
  21. Browser detection
  22. How to get the output of a System.Diagnostics.Process?
  23. ASP.NET jQuery Ajax Calling Code-Behind Method
  24. Printing from ASP.NET to a network printer
  25. no overload for method “ToString” takes 1 arguments
  26. {version} wildcard in MVC4 Bundle
  27. Built-in helper to parse User.Identity.Name into Domain\Username
  28. Are static variables thread-safe? C#
  29. Multiple signalR connections/hubs on your website
  30. What are some alternatives to ReSharper? [closed]

Leave a Comment