Oracle.DataAccess version issue

[Libertad]

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.

[Ralph Waldenmaier]

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

[Libertad]

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?

[Ralph Waldenmaier]

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

[Ahmed]

Hi