[Fix]-C# to oracle error-The provider is not compatible with the version of Oracle client
C# to oracle error-The provider is not compatible with the version of Oracle client
Error:
The provider is not compatible with the version of Oracle client
Reason:
The error occurs when trying to connect from Visual Studio 2012 to Oracle 11g R2 Client 32-bit. The connection works well locally with Oracle 11g R2 Client 64-bit server and ODAC 11.2.0.320 32-bit.
But when the site is published on the server the error occurs as “The provider is not compatible with the version of Oracle client".
Fix:
A 32-bit client works well with a 64-bit server locally. But when the site is published to the server the Oracle Data Provider for .NET (ODP.NET) versions must match exactly. Hence it is advisable to build locally with 64-bit ODP.NET if the server is 64-bit as ODP.NET is very particular about the versions.Check out this Oracle Forum, where you will find active developers fixing queries of enthusiasts like you.
