ODP.NET

Hi

I've developed an ASP.Net app on an XP machine which includes a dll that uses ODP.Net (11.1.0.6) to connect to oracle XE 10g.

This all works nicely on my XP machine, but I've come to deploy the application on our Windows 2003 x64 server and I'm having some problems. Initially I installed 10g XE and then the 32-bit ODAC, but my ASP.Net app failed to connect and this then seemed to cause oracle client to stop working until a reboot.

Now I have unistalled everything oracle related and cleared out remaining registry keys. Then idid the following:

1) Installed windows 64-bit oracle client 11.1
2) Installed Oracle XE 10g
3) Tested connection through SQLPlus - OK.
4) Deployed a test windows forms app (platform as x86) to the server to test connection (using Oracle.DataAccess) and this fails with the following error:

-------------------------------------------

System.IO.FileNotFoundException: Could not load file or assembly 'Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
File name: 'Oracle.DataAccess, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342'

-------------------------------------------

5) Installed windows 32-bit oracle client 11.1
6) Repeated step 4 - this produced the same error.

I can see the assemblies in the GAC so why can't it find them?

So far this has taken me two days and I'm getting nowhere. I have read countless forum articles and tried setting different platform targets but none of this is working. Can somebody please tell me how I get ODP.Net working on 64-bit windows???

Any help would be greatly appreciated as I have a client waiting to see their web application.

Cheers

John

Edited by: gisgeezer on Oct 28, 2009 10:32 AM