Could not load file or assembly 'Oracle.DataAccess' or one of its dependenc
967313Oct 10 2012 — edited Nov 7 2012Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.
My scenario on development machine fitted on:
1. 32-bit ODP.net installed on 32-bit O/S
2. .NET application compiled with "Any CPU" set for "Plataform target"
3. The application is then deployed to the 64-bit host with 64-bit ODP.NET installed. (I'm abble to to tnsping, connect to sqlplus)
4. The application server is x64bits and the database server is 32bits. (I'm able to run and compile the APPLICATION using visual studio in a development machine)
5. I tried the following solutions:
a) to enable 32-bit applications in my default AppPool (I get the error with CrystalDecision - SapCrystalReports in the deployment)
b) to install 32-bit ODP.net on the deployment machine with 64-bit os, but i got a runtime error
c) to set all the projects in my solutions .NET application compiled from "Any CPU" to "x64" set for "Plataform target",but the error persist
Please assist me on this issue.