Oracle.DataAccess version issue

5 posts, 0 answers
  1. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 02 Oct 2011 Link to this post

    Hi there,
    I have the following error when my application try to connect to Oracle DB:
    Could not load file or assembly 'Oracle.DataAccess, Version=2.102.2.20, Culture=neutral, PublicKeyToken=89b483f429c4724' or one of its dependencies.  The system cannot find the file specified.

    My project has a reference to Oracle.DataAccess.dll version 2.112.1.0 and it appears that this is the only DLL provided in ODP.NET.
    I uninstalled everything and reinstalled ODP.NET 11.2.0.2.1 and have the Policy.2.102.Oracle.DataAccess, Version=2.112.1.0 in GAC but I still have above error.

    Is my newer version the cause of the problem?  Does Oracle.DataAccess.dll have a dependency that is not apparent?  Any guidance would be appreciated.
  2. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 04 Oct 2011 Link to this post

    Hello Libertad,

    Please ensure that you have the same version of the ODAC driver installed as your application is.  If you are running a x86 program please install the x86 version of the Oracle ODAC drivers. The same goes for x64.
    i64 applications will need the 64 bit version of ODAC, and x86 applications will need the 32 bit versions.
    Before reinstalling the driver you could try to change the build type for your application to x86 to check if that is solving your problem. If no error comes up then, the installed driver is just the wrong one for your original project build definition.

    Hope that helps.
     

    All the best,
    Ralph
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  3. DevCraft banner
  4. Libertad
    Libertad avatar
    53 posts
    Member since:
    Sep 2008

    Posted 04 Oct 2011 Link to this post

    Hello Ralph,
    I have not any problem regarding the installed ODAC driver in my development machine which is a Win7 32bit. I have this error only on production machine which runs on Windows Server 2008 R2 64bit.
    I have installed the latest version of ODAC driver 32 bit on the server which I've downloaded from here.
    Regarding my development machine OS (Win7 32bit) the build type of my application is x86 and since 32 bit of ODAC has been installed on the server, so my application should work fine on the server, but I'm getting the above mentioned error when I run my application from server.
    What do you think Ralph?
  5. Ralph Waldenmaier
    Admin
    Ralph Waldenmaier avatar
    202 posts

    Posted 05 Oct 2011 Link to this post

    Hello Libertad,
    please see this post with the answer. For the completeness here is what I said.

    I guess you are using this DLL within an IIS setup. Have you checked that your Application Pool supports 32bit applications. This can be set in the settings of the Application Pool.

    I'm glad that I could help. Feel free to contact us for any OpenAccess problems.

    Kind regards,

    Ralph
    the Telerik team

    Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's SQL Server Community Awards. We are competing in TWO categories and every vote counts! VOTE for Telerik NOW >>

  6. Ahmed
    Ahmed avatar
    1 posts
    Member since:
    Oct 2014

    Posted 12 Oct 2014 in reply to Libertad Link to this post

    Hi
Back to Top
DevCraft banner