<div>
Use OleDbConnection, check:<br />
<br />
<a href="http://www.java2s.com/Code/CSharp/Database-ADO.net/HowtouseanOleDbConnectionobjecttoconnecttoanOracledatabase.htm" rel="ugc">http://www.java2s.com/Code/CSharp/Database-ADO.net/HowtouseanOleDbConnectionobjecttoconnecttoanOracledatabase.htm</a><br />

</div>


Use OleDbConnection, check:

http://www.java2s.com/Code/CSharp/Database-ADO.net/HowtouseanOleDbConnectionobjecttoconnecttoanOracledatabase.htm [http://www.java2s.com/Code/CSharp/Database-ADO.net/HowtouseanOleDbConnectionobjecttoconnecttoanOracledatabase.htm]


<div>
<div class="content wysiwyg-content">
Experts,<br />
I have a winforms intranet application with about 50 users. &nbsp;Use click-once to deploy from network share. &nbsp;Have requirements to fetch data from an Oracle database in our next release. &nbsp;Trying to get around having to install the Oracle 11gR2 client on everyones workstation. &nbsp;I have tried using Microsoft ODBC for Oracle and .NET Framework Data Provider for Oracle but I get this error message in VS 2010 when trying to add a Data Source:<br />
&nbsp;Unable to find the requested .Net Framework Data Provider. &nbsp;It may not be installed.<br />
<br />
What is the recommended solution for deploying a C# client winforms application (target .NET 3.5) without having the oracle client installed? &nbsp;<br />
<br />
The application will only be querying data exposed from views on oracle schema.<br />
<br />
VS 2010 C#<br />
Oracle 11gR2 standard editiion<br />
User's workstation: &nbsp;Win7 Enterprise SP 1 - 32 and 64 bit OS<br />
<br />
Thanks in advance.<br />
<br />
<br />

</div>
</div>


Experts,
I have a winforms intranet application with about 50 users.  Use click-once to deploy from network share.  Have requirements to fetch data from an Oracle database in our next release.  Trying to get around having to install the Oracle 11gR2 client on everyones workstation.  I have tried using Microsoft ODBC for Oracle and .NET Framework Data Provider for Oracle but I get this error message in VS 2010 when trying to add a Data Source:
 Unable to find the requested .Net Framework Data Provider.  It may not be installed.

What is the recommended solution for deploying a C# client winforms application (target .NET 3.5) without having the oracle client installed?  

The application will only be querying data exposed from views on oracle schema.

VS 2010 C#
Oracle 11gR2 standard editiion
User's workstation:  Win7 Enterprise SP 1 - 32 and 64 bit OS

Thanks in advance.




c# connect to Oracle 11gR2 standard edition

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).