"Providername is not compatible with the Oracle Client"

Thread is closed for posting
5 posts, 0 answers
  1. Raj
    Raj avatar
    3 posts
    Member since:
    Dec 2012

    Posted 21 Dec 2012 Link to this post

    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?

  2.
  3. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 21 Dec 2012 Link to this post

    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.
  5. Raj
    Raj avatar
    3 posts
    Member since:
    Dec 2012

    Posted 21 Dec 2012 Link to this post

    The drivers are appropriate and config file setting are same.

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

    any help?
  7. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 21 Dec 2012 Link to this post

    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.
  9. Raj
    Raj avatar
    3 posts
    Member since:
    Dec 2012

    Posted 21 Dec 2012 Link to this post

    Thanks I will try and let you know
Back to Top