This is a migrated thread and some comments may be shown as answers.

"Providername is not compatible with the Oracle Client"

4 Answers 441 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

4 Answers, 1 is accepted

answered on 21 Dec 2012, 07:50 AM

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

Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.

answered on 21 Dec 2012, 10:27 AM

OracleAdo.zip

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

Q3'12 SP1 of OpenAccess ORM packs Multi-Table Entities mapping support. Check it out.