ODP.NET

I've just attempted to installed the latest client, 11.2.0.2.0.

So far as I can tell, it didn't install a new Oracle.DataAccess.dll anywhere. I don't know why this is so difficult. Does Oracle hate .NET developers?


I've searched my entire computer for 'Oracle.DataAccess.dll' and found I have quite a few dlls and I'm not sure what the are all doing here.

Basically, it appears I have 4 versions of Oracle.DataAccess.dll.
2.112.1.1
2.112.1.2
4.112.1.1
4.112.1.2

The ones ending in .2 seem to be installed twice in two locations. In my GAC, there are two of the 4 registered there (versions 4), but only in the GAC_32 and not the 64 bit GAC.


Here are the locations:

C:\Oracle\product\11.2.0\client_2\opd.net\bin 1st one is Version 2.112.1.1 and 2nd one is Version 4.112.1.1

Two more here
D:\app\{username}\product\11.2.0\client_2\odp.net\bin 1st one is Version 2.112.1.2 and 2nd one is Version 4.112.1.2

Then the same versions again here:
D:\app\{username}\product\11.2.0\client_3\odp.net\bin 1st one is Version 2.112.1.2 and 2nd one is Version 4.112.1.2 (Only difference is the Client folder name)


I've wasted weeks now trying to get an oracle connection on a 64bit server running under IIS in 64 bit mode. Please help me before I send my computer out a third floor window!