Oracle ODP.NET

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 .
Download Here
it works

Again what a hassle it is.

Share this post: | | | |
Published Sunday, November 13, 2011 10:21 AM by cipto

Comments

No Comments