Link to home
Start Free TrialLog in
Avatar of Lawrence Avery
Lawrence AveryFlag for United States of America

asked on

What is the meaning of provider and oracle client? See detail.

I am trying to interpret what this error message means:

Oracle.DataAccess.Client.OracleException: The provider is not compatible with version of Oracle Client.

My take is Oracle.DataAccess.dll is the provider and my C# .NET program is the Oracle Client.  Am I correct in my statement?
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

The DLL is likely the provider but the client is the version of the Oracle Client installed on the machine.

You aren't using the ODP.Net Managed Client so the DLL you have needs to be compatible with the Oracle Client it is looking at.

I would STRONGLY suggest you move to the Manage Client.  It doesn't require any Oracle Client install.  You can just copy the one DLL around from machine to machine.
Hi metro156,

It looks like OraOpsXX.dll  is not compatible with  ODP.NET version or with the .NET Framework version.

For more details, Please check the below link.

https://oradim.blogspot.in/2009/09/odpnet-provider-is-not-compatible-with.html
@tapan,

>>It looks like OraOpsXX.dll  is not compatible with  ODP.NET version

It is more than one single file.  The Oracle client isn't the same as the version on the machine where the application was compiled.  The unmanaged ODP.Net client needs more than the single file you mentioned.

I believe there are 5 or 6 necessary for it to run and running in that configuration isn't Supported by Oracle.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.