[Fix]-C# to oracle error-The provider is not compatible with the version of Oracle client

Wikitechy | 3648 Views | oracle | 28 May 2016

 

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.




Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise