CODEWITHSUNDEEP
.netoracle11gwindows-server-2003oracleclientodac
Tohid
Tohid

Reputation: 6679

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

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:

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

Upvotes: 1

Views: 40416

Answers (2)

Nikhil Gaur
Nikhil Gaur

Reputation: 1272

This is an old post but for other users who might face similar problem here is a post for details instruction

http://www.codewithasp.net/2012/06/step-by-step-instructions-to-install.html

Upvotes: 1

Tohid
Tohid

Reputation: 6679

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

Upvotes: 4

Related Questions