Windows 7 x64 SP1
Visual Studio 2010
Oracle 11gR2 184.108.40.206.0 for Windows x64
Oracle Patch 12429529
I had my development machine setup and working with all of the above items except for the Oracle 11gR2(and patch), I was using a separate Oracle server. However everything went bad after the installation of 11gR2, I get the following error when trying to run the web application: "Could not load file or assembly 'Oracle.DataAccess, Version=220.127.116.11, Culture=neutral'"...
My application is built in .NET 3.5 and the application pool is in 32 bit mode in IIS 7.
Do I have to do something with the assembly rebind trick?:
I don't run Oracle server locally just avoid stuff like this, but since you installed an x64 server while having the application running in x86 mode, one potential issue is that the binding redirect you were using is no longer working because it's set for the 64 bit version instead. You don't have 18.104.22.168 on the machine at all, so try deleting that reference and pointing directly at your ODAC version.
Alternately reconfigure the project to compile for x64 and disable 32 bit mode in IIS, then use the 64 bit client.
Normally I install 11gR2 x64 then install the ODAC afterwards. Then everything works on my application, but when I do that I have issues with logging in using windows authentication at the command prompt other items like that.
the assembly is still present in the C:\Windows\assembly directory...
Oracle.DataAccess 22.214.171.124 x86
Isn't there anyway to get the applications to see this assembly in the GAC? since it is truly there?
It should be. Have you tried removing the reference your application has now and re-adding it for the version you want to use?
Alternately if it's something you can use in your situation, have you tried using the managed provider beta? That's just a single assembly that doesn't rely on Oracle clients at all and really solves a lot of this type of stuff.
Well since we have a bunch of applications that all use the same version and production uses that same version, I was trying not to modify the reference.
If I install 11gR2 then install the ODAC everything works fine on the applications, but I can't login with the operating system credentials and I can't use OEM.
Yeah that sounds like the classic case of multiple Oracle clients on the same system not playing nice. I've found it easier to just avoid it whenever possible, so I can't be of much help troubleshooting it. Sorry.
(If you have a chance though, try the managed provider beta for your client software instead. It's shaping up to be a great solution to this type of thing.)
Sorry , but I did know where to place my question, so I decided to place it here , because this topic is closer one to my question.
If I use Oracle Express Edition (11g) in developping my application , and I would like to use ODAC driver for .Net Entity framework in order to access Oracle DB from .Net application, have I pay for ODAC driver or not in this case?