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
Oracle Database

Avatar of undefined
Last Comment
slightwv (䄆 Netminder)

8/22/2022 - Mon
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.
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
slightwv (䄆 Netminder)

>>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/Database/Oracle/Q_27020817.html
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
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
slightwv (䄆 Netminder)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question