472,784 Members | 1,020 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,784 software developers and data experts.

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 2307

"Mike D" <Mi***@discussions.microsoft.com> wrote in message
news:D4**********************************@microsof t.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***@discussions.microsoft.com> wrote in message
news:D4**********************************@microsof t.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***@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.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***@discussions.microsoft.com> wrote in message
news:A6**********************************@microsof t.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
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...
3
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...
4
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....
13
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....
0
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...
0
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...
8
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...
4
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...
9
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....
0
by: Rina0 | last post by:
Cybersecurity engineering is a specialized field that focuses on the design, development, and implementation of systems, processes, and technologies that protect against cyber threats and...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.