Could not load file or assembly Oracle.DataAccess

asp.net-mvc oracle entity-framework entity-framework-4 odp.net
user975260 picture user975260 · Dec 28, 2011 · Viewed 45.4k times · Source

I have an asp.net mvc (EF) project , I had downloaded oracle data provider with version 4.112.2.50 -32bit on my pc when moving project to windows server 2008 (I have the same version of odp-64bit) I have the below problem:

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.

when I toke Oracle the "Oracle.DataAccess.dll" from the server and make it with my project reference I have another error message like the above with a file "Oracle.Web"

Could not load file or assembly 'Oracle.Web' or one of its dependencies. An attempt was made to load a program with an incorrect format.

also if I get the File "Oracle.Web.dll" to my project reference from the server I have the same error with "Oracle.Web"

Answer

McHaroni picture McHaroni · Jul 18, 2012

In the IIS Manager select your server and select "Application Pools". Select the application pool used by your Web App and click on "Advanced Settings" from the right hand menu.

In the "General Section" of the advanced Settings click on the "Enable 32-bit Applications" and set it to True.

This fix only applies to 64-bit servers that attempt to execute the 32-bit version of the Oracle Dlls.

Regards George

Related questions

Oracle Instant Client and Entity Framework trouble with configuration

I'm trying to learn and figure out if it is possible to deploy an MVC, EF, ODAC 11.2.0.3 app to a server that has a previous version of ODP.NET installed. Rather than updating the sever ODP.NET (which I can't), …

Read More
Table Does Not Exist while using EF 6 and Oracle.ManagedDataAccess

I am creating a MVC application using EF 6.0.0.0 and ODP.Net Oracle.ManagedDataAccess version 4.121.2.0 for the data access. In my Controller called EmployeeController, I have the following code snippet: public ActionResult Details(int id) { try { EmployeeContext employeeContext = new EmployeeContext(); Employee …

Read More
JQuery - $ is not defined

I have a simple jquery click event <script type="text/javascript"> $(function() { $('#post').click(function() { alert("test"); }); }); </script> and a jquery reference defined in the site.master <script src="<%=ResolveUrl("~/Scripts/jquery-1.3.2.js")%&…

Read More