Oracle client and .net - .NET Framework

Mike D

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

Subscribe Reply

2372

Gerald Hernandez

"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

Mike D

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

Gerald Hernandez

"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

Mike D

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

Similar topics

9106

Minimum requirements for ODBC connectivity to Oracle database

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

Oracle Database

30408

How to Clear the List of Oracle Client Homes install on a User Machine...

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 Database

16822

Oracle 7.3 v 9.2 client connection problems

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):

Oracle Database

7458

Oracle Adventures

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

ASP.NET

1722

Deploy web app. with Oracle Client on a different drive than the a

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

ASP.NET

11009

Oracle client and networking components were not found.

by: petro | last post by:

ASP.NET

313

Oracle client and .net

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

.NET Framework

5709

Asp.net / iis / oracle problem

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 =...

ASP.NET

2403

If you connect to Oracle through .NET please help!

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

Visual Basic .NET

7915

What is ONU?

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

General

8204

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

8220

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6617

AI Job Threat for Devs

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

Career Advice

5712

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

3838

Trying to create a lan-to-lan vpn between two differents networks

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

Networking - Hardware / Configuration

2345

transfer the data from one system to another through ip address

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

C# / C Sharp

1452

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1184

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General