System.Data.OracleClient vs Oracle.DataAccess

6 posts, 0 answers
  1. Rui
    Rui avatar
    30 posts
    Member since:
    Feb 2012

    Posted 10 Apr 2012 Link to this post

    Hello, if I want set to use providername = System.Data.OracleClient
    why is openaccess complaining about Oracle.DataAccess?

    It's a 3.5 application.


    System.Configuration.ConfigurationErrorsException: Database provider Oracle.DataAccess.Client.OracleClientFactory, Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342 not installed properly (CLR=v2.0.50727 32bit). ---> System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
    File name: 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c47342'
       at System.RuntimeTypeHandle._GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, Boolean loadTypeFromPartialName)
       at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
       at System.RuntimeType.PrivateGetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark)
       at System.Type.GetType(String typeName, Boolean throwOnError)
       at OpenAccessRuntime.ProviderFactoryLoader.LoadImpl(String name, LogEventStore log, Int32 id)
  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 11 Apr 2012 Link to this post

    Hello Rui,

    The provider System.Data.OracleClient is a Oracle client provided by Microsoft within the .NET framework. Since this provider is deprecated, it is recommended to use the Oracle.DataAccess.Client which is provided by Oracle. You can download the provider here
    You can find additional information in our documentation.

    Feel free to ask if you have any other question.

    Regards,
    Ralph
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
  3. DevCraft banner
  4. Rui
    Rui avatar
    30 posts
    Member since:
    Feb 2012

    Posted 11 Apr 2012 Link to this post

    OK. I understand.
    So we should not use System.Data.OracleClient.

    Note: Check the documentation it's missing something.

    "... has been tested with the 9, 10R2 an"  maybe you wanted to say: and 11....
  5. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 12 Apr 2012 Link to this post

    Hello Rui,
    Yes, you should not use the System.Data.OracleClient client, but the ODP.NET client provided by Oracle.

    Thank you for the documentation hint. We will correct this. 

    Greetings,
    Ralph
    the Telerik team
    Telerik OpenAccess ORM Q1 2012 release is here! Check out what's new or download a free trial >>
  6. Sushil
    Sushil avatar
    1 posts
    Member since:
    Apr 2013

    Posted 23 May 2013 Link to this post

    Hello Everyone,
                I am also getting same error, can anyone please help me. Its urgent .
  7. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 23 May 2013 Link to this post

    Hi Sushil,

    Can you please ensure that you have installed the appropriate Oracle .Net Client provided by Oracle. It can be found here. Also please ensure that you have installed the architecture version that matches your applications architecture. In case you specified 'Any CPU' then you need to install the version based on the architecture of your operating system.

    Hope this helps.
    Do come back in case you need further assistance.

    Regards,
    Ralph
    Telerik
    OpenAccess Samples Kit boasts 50+ sample applications providing diverse real-life business solutions. Click to read more and see OpenAccess ORM in action.
Back to Top
DevCraft banner