Last post Aug 15, 2016 04:28 PM by strangermike
Aug 12, 2016 03:36 PM|StrangerMike|LINK
I developed a VS 2012 application on my 32 bit machine. The application works with Oracle in my local environment.
When I move it to our production web server (a Windows Server 2012 R2 64 bit operating system), I get this infamous error:
Could not load file or assembly 'Oracle.DataAccess, Version=18.104.22.168,
Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies.
The system cannot find the file specified.
I have set the Enable 32 Bit applications to True, yet I still get the error.
The Oracle version installed on the Prod server is: ODAC112030_x64_Release 3.
What can I do to get to work?
Aug 12, 2016 11:44 PM|Lannie|LINK
On the production server install the 32-bit version of ODP.NET client.
Install in the same oracle base directory BUT in a second Oracle Home directory.
the 64-bit and 32-bit ODAC client installers then set up policies in the GAC to handle both 32-bit and 64-bit apps.
I also do this.
I put my 32-bit Oracle.DataAccess.dll in the /BIN folder of my application, make LOCAL reference and then compile.
Now the ODAC is less dependent on GAC.
Aug 15, 2016 04:28 PM|StrangerMike|LINK
I installed a 32 bit version (which I thought I had on there already). I put the dll file in the Bin folder.
I got passed the original error, then started having a TNS issue, which I included in the Client_1 and Client_2 files.
I came in this morning and for some reason production server was rebooted and the TNS issue went away!
So as of this morning, the program works. Thanks