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

at999
at999 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
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.

Author

Commented:
>> 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
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
>>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:
http://www.experts-exchange.com/Database/Oracle/Q_27020817.html

Author

Commented:
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
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Correct.  ODAC also has some development tools with it but other than that, it is just a quick way to get started developing with Oracle.  If you look at the link you provided, it tells you what all is included with ODAC.  Notice the last item:  Oracle Instant Client 11.2.0.3.0

It is basically all the data providers and the Instant Client...  Just like any other client install...

ODP.Net is just part of the ODAC just like it is an option with the Client.  It is just a product.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial