How to Install "Oracle Data Access Components (ODAC)" on Windows Server 2003 R2?

.net oracle11g windows-server-2003 oracleclient odac
Tohid picture Tohid · Apr 16, 2013 · Viewed 38.9k times · Source

I recently installed "32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio" on my computer (Windows 7, 64bit). Everything seems fine and I can develop and run my application in Visual Studio 2010 and IIS 7.

Now, when I deploy my application to the Server, it raises error:

Exception: System.TypeInitializationException: The type initializer for 'Oracle.DataAccess.Client.OracleCommand' threw an exception. ---> Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

Obviously I need to install ODAC on the server, too. My server is:

  • Windows 2003 32 bit R2 (I know, I know!)
  • IIS 6

So. I downloaded the same installation from Oracle website (ODAC 11.2 Release 5 and Oracle Developer Tools for Visual Studio [11.2.0.3.20]) and installed it on the server. But still getting the same error.

PS: When I was installing, I chose Oracle Data Access Component for Oracle Client 11.2.0.3.20 in Oracle Universal Installer. hmmmm. Should I choose "Oracle Server" instead?

enter image description here

Answer

Tohid picture Tohid · Apr 24, 2013

The first option (Oracle Data Access Component for Oracle Client 11.2.0.3.20) worked for me.

Related questions

BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed

I am getting this error while on of my .Net application are trying to make a connection to oracle database. The error says that This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.. …

Read More
Installing ODP.net on server to resolve Oracle.DataAccess.Client.OracleException: The provider is not compatible with the version of Oracle client

I have a test environment for a service that my site will be using and a production environment. In my test environment I have ODP.net installed on the server. That service that uses Oracle seems to be running pretty …

Read More
Replacing System.Data.OracleClient to Oracle.DataAccess (ODP.NET)

I have a project which is using System.Data.OracleClient at the moment and since it is being deprecated so I want to switch to the ODP.NET latest version for Oracle 11g. Please let me know if the following …

Read More