Link to home
Start Free TrialLog in
Avatar of at999
at999

asked on

Oracle 11r2 client Versus Oracle Dataprovider for .net(ODAC/ODP .net)

I have .net application that connects to oracle database using oracle-dataprovider for .net(ODAC) Link -  
http://www.oracle.com/technetwork/database/windows/downloads/index-101290.html
In that link i have installed on my machine
ODAC 11.2 Release 4 (11.2.0.3.0) with Oracle Developer Tools for Visual Studio

I am able to run that application on my machine and it can connect to oracle database

Now, do i have to install that ODAC 11.2(Oracle dataprovider for .net)  on users's machines. My users have Oracle 11r2 client already installed  on their machines.  

thanks
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

You do not need to install the ODAC on the users machine IF ODP.Net was selected when the client was installed.  It is an option when you run the client setup.

You should also be aware that the ODP.Net versions must match EXACTLY.
Avatar of at999

ASKER

>> You should also be aware that the ODP.Net versions must match EXACTLY.

do you mean the version of ODP.NET that I have used to build my application should match
the with the version of odp.net (that was installed along with oracle client) on client's machine
>>should match  the with the version of odp.net (that was installed along with oracle client) on client's machine

Yes.  Exactly.

There is a detailed discussion of this here:
https://www.experts-exchange.com/questions/27020817/The-provider-is-not-compatible-with-the-version-of-Oracle-client.html
Avatar of at999

ASKER

Does that mean that i donot need oracle-dataprovider for .net(ODAC) installed on my machine(which i use to build my .net applications) and I could have used the ODP.NET that came along with oracle 11r2 client(The complete client)  in order to build my .net application..

 thanks
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial