Oracle has shifted it’s Newest oracle 11g to a new DLL, and it’s using the efficiency from ado.net and other stuff.
Despite like that it has lack support in Enterprise Library, and you might want to define new database by your self or just use direct oracle client.
The previous one system.data.oracleclient will work for Oracle 9-10g. and for 11 , you have to use this ODP.NET. One main problem that I encounter is the lack of deployment support.
if you want to deploy your application , you have to install oracle client on client computer. that is about 233 MB or more. and that is huge.
Oracle has this XCOPY which meant to be , you just copy your dll to someplace and it should run, but it’s not.
there are lot’s of setting and error on this oracle environment thing
so although you already did what they told us to , Detail
still no luck, Try this and that a lot (copy folder,env variable,c++ runtime).
I get Oracle Exception "The provider is not compatible with the version of Oracle client".
It's because odp.net also have not so good Error message, everything that goes wrong will pop up this message.
have look on the related forum also.
So what I did for last try is to install the ODTwithODAC112021 32 Bit version.
I select the Client one.set it to c:\app .
Again what a hassle it is.