Can't Get ODP.NET To Work
I'm having issues with ODP.NET. We just set up a new Windows Server 2008 x64 box and installed the latest Oracle 11.1.0.7.0 for Windows Server 2008 x64. The Oracle database works fine.
I tried to deploy an ASP.NET (3.5) web application to the same box, but I can't seem to get ODP.NET to work. It looks like Oracle 11g also installed Oracle.DataAccess 2.111.6.20 and 2.111.7.0 (I see them in the GAC and the Oracle home) but neither one will work. If I attempt to use the 2.111.6.20 DLL, I receive the following error: "The provider is not compatible with the version of Oracle client". Modifying the web.config file to look for the 2.111.7.0 DLL produces this error: "Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.".
I can understand why the 2.111.6.20 version doesn't work, because that's built for 32-bit systems and I'm on a 64-bit system. However, I have attempted to install an XCOPY version of ODAC 11.1.0.6.21 but can't get that to work, either.
I would prefer to use the 2.111.7.0 version because that's built for x64. I've looked for a 64-bit version of ODAC 11g where I could attempt an XCOPY installation as well, but the page states: "64-bit Oracle 11g ODAC for Windows x64 is available on Oracle Metalink as part of Oracle Database downloads." I've searched metalink but can't find it. Does this mean it's included with the database? If so, what am I doing wrong?
Any help would be greatly appreciated.