473,886 Members | 2,375 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Oracle client and .net

I want to connect to an oracle database from my client pc, OS is win2k or XP.

Can I connect to an oracle database without having the full oracle client
installed? If so what would be the minimum install on the client to get this
connection? Oracle version is 9i?

I found the .NET Managed Provider for Oracle and it looked like it still
needed the oracle client?

Mike
Jul 21 '05 #1
4 2388

"Mike D" <Mi***@discussi ons.microsoft.c om> wrote in message
news:D4******** *************** ***********@mic rosoft.com...
I want to connect to an oracle database from my client pc, OS is win2k or XP.
Can I connect to an oracle database without having the full oracle client
installed? If so what would be the minimum install on the client to get this connection? Oracle version is 9i?

I found the .NET Managed Provider for Oracle and it looked like it still
needed the oracle client?

Mike


Yes, you must install the Oracle Client. Even though you may have one or
more providers available, all of them would be dependant upon the actual
client being installed. The various providers are intermediary interfaces to
the underlying Oracle Client, and can expose varying degrees of the actual
Oracle Clients capabilities.

IIRC, the Oracle Client installer has a "minimum" option.

Gerald
Jul 21 '05 #2
Thanks for the reply. Are you familiar with the ".NET Managed Provider for
Oracle" found here
http://www.microsoft.com/downloads/d...displaylang=en. What does it do?

Thanks again
Mike

"Gerald Hernandez" wrote:

"Mike D" <Mi***@discussi ons.microsoft.c om> wrote in message
news:D4******** *************** ***********@mic rosoft.com...
I want to connect to an oracle database from my client pc, OS is win2k or

XP.

Can I connect to an oracle database without having the full oracle client
installed? If so what would be the minimum install on the client to get

this
connection? Oracle version is 9i?

I found the .NET Managed Provider for Oracle and it looked like it still
needed the oracle client?

Mike


Yes, you must install the Oracle Client. Even though you may have one or
more providers available, all of them would be dependant upon the actual
client being installed. The various providers are intermediary interfaces to
the underlying Oracle Client, and can expose varying degrees of the actual
Oracle Clients capabilities.

IIRC, the Oracle Client installer has a "minimum" option.

Gerald

Jul 21 '05 #3

"Mike D" <Mi***@discussi ons.microsoft.c om> wrote in message
news:A6******** *************** ***********@mic rosoft.com...
Thanks for the reply. Are you familiar with the ".NET Managed Provider for Oracle" found here
http://www.microsoft.com/downloads/d...displaylang=en.
What does it do?
Thanks again
Mike


Generic ADO is "simple" and easy to use. However, it provides only generic
database access. You don't typically have access to the specialized
capabilities of whatever underlying database system you are connecting to.
Well, not easily, and it is optimized mostly for MS SQL Server. The problem
is that there are frequently things you need to do with Oracle that work
differently than SQL Server. Because of this, the normal ADO providers just
don't work all that well with Oracle. Note that it is still possible, and in
some cases practical, to use generic ADO to interface to Oracle, but with
limited functionality.

The native Oracle Client is very powerful and feature rich. However, it is
far from easy to use, and so specialized that it severely limits the
possibility of code reuse; Which ADO does very well.

The ".NET Managed Provider for Oracle" provides an in-between step. It
combines the standardized interfaces and ease of use of generic ADO, but
also is tuned to work closely with the capabilities of Oracle. So you get a
reasonable compromise between the power of the Oracle native drivers and the
simplicity and portability of ADO. Note, that it still interfaces with
whatever Oracle Client driver you have installed, it in itself is not a
driver, but a user friendly interface to the driver that is installed.

Unless you are writing an application that requires the absolute best
possible performance, access to low level objects, and only works with a
specific version of Oracle, then I would use the .NET Managed Provider for
Oracle. If you do need that low level access, then you could use the native
Oracle Driver. But even then I would recommend keeping that to a minimum and
only when necessary. Just not that friendly IMHO.

Gerald

Jul 21 '05 #4
Thanks very much for the detailed reply. I am new to Oracle and have alot to
learn.

Thanks
Mike

"Gerald Hernandez" wrote:

"Mike D" <Mi***@discussi ons.microsoft.c om> wrote in message
news:A6******** *************** ***********@mic rosoft.com...
Thanks for the reply. Are you familiar with the ".NET Managed Provider

for
Oracle" found here

http://www.microsoft.com/downloads/d...displaylang=en.
What does it do?

Thanks again
Mike


Generic ADO is "simple" and easy to use. However, it provides only generic
database access. You don't typically have access to the specialized
capabilities of whatever underlying database system you are connecting to.
Well, not easily, and it is optimized mostly for MS SQL Server. The problem
is that there are frequently things you need to do with Oracle that work
differently than SQL Server. Because of this, the normal ADO providers just
don't work all that well with Oracle. Note that it is still possible, and in
some cases practical, to use generic ADO to interface to Oracle, but with
limited functionality.

The native Oracle Client is very powerful and feature rich. However, it is
far from easy to use, and so specialized that it severely limits the
possibility of code reuse; Which ADO does very well.

The ".NET Managed Provider for Oracle" provides an in-between step. It
combines the standardized interfaces and ease of use of generic ADO, but
also is tuned to work closely with the capabilities of Oracle. So you get a
reasonable compromise between the power of the Oracle native drivers and the
simplicity and portability of ADO. Note, that it still interfaces with
whatever Oracle Client driver you have installed, it in itself is not a
driver, but a user friendly interface to the driver that is installed.

Unless you are writing an application that requires the absolute best
possible performance, access to low level objects, and only works with a
specific version of Oracle, then I would use the .NET Managed Provider for
Oracle. If you do need that low level access, then you could use the native
Oracle Driver. But even then I would recommend keeping that to a minimum and
only when necessary. Just not that friendly IMHO.

Gerald


Jul 21 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
9133
by: Alex | last post by:
I have developed a VB application that uses Oracle 8i database for backend. The database server is on the local network. From my development machine, the application connects (via ODBC) to the database successfully. The problem is that I want to install this application on several Windows 2000 client machines that do not have Oracle client installed (hence missing all the ODBC connectivity support files/drivers). What is the minimum...
3
30504
by: John | last post by:
Hi. We had a PC that had Oracle Client 8.0.5 and 8.1.7 installed in Default_Home (c:\orant) and Default_Home1 (c:\oracle). A third party package, installed certain components of Oracle Client 9.0.2 in another Oracle Home which it called ora92 (c:\oracle\ora92). Since we no longer need Clients 8.0.5 and 8.1.7, I decided to uninstall all Oracle clients and install Oracle client 9.0.2. I used Oracle installer to
4
16853
by: Tig | last post by:
Hi all. I have a need to connect to an Oracle 7.3.3.5 database. I have a user who successfully connects to it with her Oracle 7.3 client. I have an Oracle 9.2 client installed on my machine. I had her send me her tnsnames.ora from her PC. The entry I wanted was as follows (some letters replaced with xxx for security reasons):
13
7488
by: Chris Botha | last post by:
The machine is running XP Pro with all the latest service packs, etc. I must access an Oracle database so I installed the Oracle client stuff. I can query Oracle from a Windows app, no problem. Using the exact same code (copy and paste) into a Web app I get the following error "Error while trying to retrieve text for error ORA-01019". Security I thought, so I use Impersonation on the Web site, then the aspnet_wp.exe crashes with "The...
0
1736
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g installed and my application works. But on the Web server I get the error below. I believe it is because the Oracle client was not installed on the web server. The web server has two drives, our techs installed the oracle client on one drive and my...
0
11040
by: petro | last post by:
I am trying to deploy an asp.net application to my web server. My application uses system.data.oledb to connect to an oracle database. On my development machine I have the oracle client 10g installed and my application works. But on the Web server I get the error below. I believe it is because the Oracle client was not installed on the web server. The web server has two drives, our techs installed the oracle client on one drive and my...
8
313
by: Mike D | last post by:
I want to connect to an oracle database from my client pc, OS is win2k or XP. Can I connect to an oracle database without having the full oracle client installed? If so what would be the minimum install on the client to get this connection? Oracle version is 9i? I found the .NET Managed Provider for Oracle and it looked like it still needed the oracle client? Mike
4
5737
by: BookerW | last post by:
I am not sure which forum I should post this on, but here is the problem. I have a front end web application(VB) on asp,net 1.1 framework. Inside of the code, I have the following lines to connect to the database If gbSQLServer Then 'sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\w\vgyl\hy.mdb" gsConnectionString = "Provider=SQLOLEDB;Data Source=frt4;Initial Catalog=SRMSM;Integrated Security=SSPI" Else
9
2425
by: D. Patrick | last post by:
I need to connect to an Oracle database. I've never done it before. I see that with framework 1.1 you had to download ODP.NET from Oracle's site in order for the framework classes to even work. I tried that quickly, but the file is 400 MB, and the the installation asks for all kinds of things in order to install. Now I'm very confused. a) Do you still need ODP.NET with framework 2.0? b) Do you need to download and install other...
0
9956
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10770
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10872
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9592
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7139
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5808
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6010
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4627
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4235
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.