"Providername is not compatible with the Oracle Client"

[Raj]

Error message "Providername is not compatible with the Oracle Client"

Environmnet : Visual STudio 2010

Oralce 11g database

Telerik ORM 11.2.7.3

Installed ODP.NET

Note: Able to connect to Oracle with Toad.

any help please?

[Ralph Waldenmaier]

Hello Raj,
The installed version of your ODP.NET driver must match the version of the program where you want to use it. If your application runs as x64, then you need to have installed the ODP.NET x64 version. Is this the case on your machine? The appropriate driver can be found here.
Additionally please check if you have the appropriate factory entry in your machine config. See the following as an example.

<DbProviderFactories>
    <add name="Oracle Data Provider for .NET" invariant="Oracle.DataAccess.Client" description="Oracle Data Provider for .NET" type="Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=4.112.3.0, Culture=neutral, PublicKeyToken=89b483f429c47342"/>
</DbProviderFactories>

If you are working with the Oracle ODP.NET instant client, then you might find this discussion on stack overflow interesting.

Hope this helps.
Do come back if you need further assistance.
Greetings,
Ralph
the Telerik team

[Raj]

The drivers are appropriate and config file setting are same.

Installed full version of ODP.NET client. Still facing the issue?

any help?

[Ralph Waldenmaier]

Hello Raj,

Attached you can find a small application that basically loads a OracleFactory via a provider name. This is also used within OpenAccess. Can you please check that this is working when you compile it with x86 and with x64 settings. What happens if you specify Any CPU?
Basically when this exception is thrown, the managed oracle driver uses the unmanaged OraOps11w.dll to check the version compatibility. There seems to be a version mismatch in your setup that causes this error.
Do you have more then one Oracle client installed on this machine? Which one will be resolved first? This can basically be derived from the Path environment variable. In my case it the first one is "C:\app\ralph\product\11.2.0\client_2".
Also can you provide more details about the environment where you are using this. Are you working with a web application?

I am looking forward to hearing from you soon and getting this solved with you.

Regards,
Ralph
the Telerik team

[Raj]

Thanks I will try and let you know