472,331 Members | 1,608 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Does 2.0 still require ODP.NET to connect to Oracle?

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 Oracle files, too?
c) Do the answers to the ODP.NET questions about service names and host
names even matter when I'm going to be using a connection string inside my
code? Is my connection string somehow tied to those answers?
d) Can you refer to the server's IP address in your connection string
instead of the server name?

I can't find any good articles about this, and so your help above is
appreciated.
Jun 22 '06 #1
7 4230
A.) You've never needed ODP.net, just the Oracle client.
B.) Microsoft has their own managed data provider for Oracle
(System.Data.OracleClient) but it's still built on top of the Oracle
OCI libraries.
C.) Not sure which questions you're speaking of but you'll still need
some way for the client to resolve the server (naming method specified
in sqlnet.ora).
D.) Do you mean when using the HOSTNAME naming method?

Patrick wrote:
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 Oracle files, too?
c) Do the answers to the ODP.NET questions about service names and host
names even matter when I'm going to be using a connection string inside my
code? Is my connection string somehow tied to those answers?
d) Can you refer to the server's IP address in your connection string
instead of the server name?

I can't find any good articles about this, and so your help above is
appreciated.


Jun 23 '06 #2
I really appreciate your help because I have had nothing but confusion.

A) Even the "Oracle Database 10g Client Release 2 (10.2.0.1.0)" is 475 MB
(compressed)! Why do we need such a heavy underlying bit of stuff just to
make a connection to a database? I don't want to install 1 GB
(uncompressed) of junk on every server that needs an Oracle connection. Is
there not a simple way of just installing, say, 50 MB of needed DLLs, with a
simple couple-click install? Kind of like installing MDAC, to make my
point.

C) What I meant was that any of these Oracle installs ask for information
like service names and stuff. Are those answers irrelevant when I'm doing
..NET connections? Or will my .NET connections somehow reference some schema
that I define in my answers during the OCI install. What and where is
SQLNET.ORA ? And how do I edit it? I want tcp/ip. I've never done this.
I thought using the Oracle provider from .NET would be easy, but suddenly it
seems I have to know all kinds of stuff about Oracle's methodologies and
installs, and that is where I'm completely clueless, sorry.

D) I want to use a connection string that references the IP address of the
server, like:

"Data Source=123.123.123.123;User Id=username;Password=passwd;Integrated
Security=no;"

Can I do that? This thinking of mine is why I think that my answers to the
OCI install questions should be irrelevant because I'm specifying the
parameters here (except for indicating the tcp/ip preference, of course).

E) The DBA passed along a "service name" and a "host string" in addition to
my username and password. Where do those go? I'm a SQL Server person, and
those concepts are foreign to me. Similarly, I don't understand why I
don't specify a database name in my connection string, like I do with SQL
Server. ?

Thank you for any specifics you can provide. I do appreciate your help.
<sd********@gmail.com> wrote in message
news:11*********************@r2g2000cwb.googlegrou ps.com...
A.) You've never needed ODP.net, just the Oracle client.
B.) Microsoft has their own managed data provider for Oracle
(System.Data.OracleClient) but it's still built on top of the Oracle
OCI libraries.
C.) Not sure which questions you're speaking of but you'll still need
some way for the client to resolve the server (naming method specified
in sqlnet.ora).
D.) Do you mean when using the HOSTNAME naming method?

Patrick wrote:
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 Oracle files, too?
c) Do the answers to the ODP.NET questions about service names and host
names even matter when I'm going to be using a connection string inside
my
code? Is my connection string somehow tied to those answers?
d) Can you refer to the server's IP address in your connection string
instead of the server name?

I can't find any good articles about this, and so your help above is
appreciated.

Jun 23 '06 #3
D. Patrick wrote:
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 Oracle files, too?
c) Do the answers to the ODP.NET questions about service names and host
names even matter when I'm going to be using a connection string inside my
code? Is my connection string somehow tied to those answers?
d) Can you refer to the server's IP address in your connection string
instead of the server name?

I can't find any good articles about this, and so your help above is
appreciated.


DataDirect http://www.datadirect.com/products/net/index.ssp
offers a 100% managed solution that is able to connect directly to an
oracle host without oracleclient installation

So is Corelabs OraDirect http://crlab.com/oranet/

Jesse Houwing
Jun 23 '06 #4
D. Patrick wrote:
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?
You need the Oracle client. ODP.Net is Oracles own implementation of a
ado.net driver.
b) Do you need to download and install other Oracle files, too?
These files are the ones that are needed. The Oracle Client Interface.
c) Do the answers to the ODP.NET questions about service names and host
names even matter when I'm going to be using a connection string inside my
code? Is my connection string somehow tied to those answers?
These answers never mattered to me, I always skip them during
installation and everything just works, but then again all naming and
network settings are pushed to the client pcs by the it department :)

The standard microsoft and oracle ado.net drivers require tnsnames
information to be stored somewhere. They can't connect directly to a
host/port.
d) Can you refer to the server's IP address in your connection string
instead of the server name?
No.
I can't find any good articles about this, and so your help above is
appreciated.


MSDN has a list of requirements:
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/WD_ADONET/html/054f76b9-1737-43f0-8160-84a00a387217.htm

There are also a number of 3rd party oracle drivers for .Net, which
offer additional functionality over the standard microsoft oracle driver:
- Oracle offers ODP.Net with their client library, this is mostly a
drop-in replacement for the standard ms driver.
- DataDirect offers a 100% managed oracle driver solution that also
targets Sybase, MS SQL and other databases. more information here:
http://www.datadirect.com/products/net/index.ssp. This driver can also
connect directly to an oracle host (see:
http://media.datadirect.com/download...tref/title.htm)
- CoreLabs OraDirect is also a 100% managed library able to connect
directly to oracle over TCP/IP. They have a library that is just for
oracle. http://crlab.com/oranet/

Kind Regards,

Jesse Houwing
Jun 23 '06 #5
D. Patrick wrote:
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.
unless you use the expensive datadirect oracle provider, you need the
oracle CLI installed, which is a massive download. You also need that
installed for the MS oracle provider.

The 10.2 ODP.NET is a huge download also because it's beta. Oracle
expects to have it trimmed down to about 260MB when it gets final
(that's what they told me anyway)
a) Do you still need ODP.NET with framework 2.0?
you can also use the 9.2.0.7 odp.net version if you are using Oracle 9i
b) Do you need to download and install other Oracle files, too?
no
c) Do the answers to the ODP.NET questions about service names and
host names even matter when I'm going to be using a connection string
inside my code? Is my connection string somehow tied to those
answers?
service names etc. are used to setup tsnname data, so you can refer to
a database by using a single name. So yes that's tied to what you
specify in the connection string.
d) Can you refer to the server's IP address in your
connection string instead of the server name?


I don't think that's possible, though it's a no-brainer to walk
through the wizard which sets up a tsn name.

If you want to go with the MS oracle provider, you can use the oracle
client installation files, and don't need ODP.NET. However you also
miss a lot of features and have to deal with the quircks build into the
MS provider, like no support for xml types and all NUMBER(x,y) types
will be a system.decimal.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Jun 23 '06 #6

"Frans Bouma [C# MVP]" <pe******************@xs4all.nl> wrote in message
news:xn***************@news.microsoft.com...
D. Patrick wrote:
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.


unless you use the expensive datadirect oracle provider, you need the
oracle CLI installed, which is a massive download. You also need that
installed for the MS oracle provider.

The 10.2 ODP.NET is a huge download also because it's beta. Oracle
expects to have it trimmed down to about 260MB when it gets final
(that's what they told me anyway)
a) Do you still need ODP.NET with framework 2.0?


you can also use the 9.2.0.7 odp.net version if you are using Oracle 9i
b) Do you need to download and install other Oracle files, too?


no
c) Do the answers to the ODP.NET questions about service names and
host names even matter when I'm going to be using a connection string
inside my code? Is my connection string somehow tied to those
answers?


service names etc. are used to setup tsnname data, so you can refer to
a database by using a single name. So yes that's tied to what you
specify in the connection string.
d) Can you refer to the server's IP address in your
connection string instead of the server name?


I don't think that's possible, though it's a no-brainer to walk
through the wizard which sets up a tsn name.

If you want to go with the MS oracle provider, you can use the oracle
client installation files, and don't need ODP.NET. However you also
miss a lot of features and have to deal with the quircks build into the
MS provider, like no support for xml types and all NUMBER(x,y) types
will be a system.decimal.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

How would I refer to the tsnname in the connection string?

Why didn't I see a tcp/ip connectivity option in the ODP.NET installation,
when it was trying to set up the schema or tsnname or whatever it was doing?
Jun 23 '06 #7
D. Patrick wrote:

"Frans Bouma [C# MVP]" <pe******************@xs4all.nl> wrote in
message news:xn***************@news.microsoft.com...
D. Patrick wrote:
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.

unless you use the expensive datadirect oracle provider, you need
the oracle CLI installed, which is a massive download. You also
need that installed for the MS oracle provider.

The 10.2 ODP.NET is a huge download also because it's beta. Oracle
expects to have it trimmed down to about 260MB when it gets final
(that's what they told me anyway)
a) Do you still need ODP.NET with framework 2.0?


you can also use the 9.2.0.7 odp.net version if you are using
Oracle 9i
b) Do you need to download and install other Oracle files, too?


no
c) Do the answers to the ODP.NET questions about service names and
host names even matter when I'm going to be using a connection

string >> inside my code? Is my connection string somehow tied to
those >> answers?

service names etc. are used to setup tsnname data, so you can refer
to a database by using a single name. So yes that's tied to what you
specify in the connection string.
d) Can you refer to the server's IP address in your
connection string instead of the server name?


I don't think that's possible, though it's a no-brainer to walk
through the wizard which sets up a tsn name.

If you want to go with the MS oracle provider, you can use the
oracle client installation files, and don't need ODP.NET. However
you also miss a lot of features and have to deal with the quircks
build into the MS provider, like no support for xml types and all
NUMBER(x,y) types will be a system.decimal.

FB

--
--------------------------------------------------------------------
---- Lead developer of LLBLGen Pro, the productive O/R mapper for
.NET LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
--------------------------------------------------------------------
----

How would I refer to the tsnname in the connection string?

Why didn't I see a tcp/ip connectivity option in the ODP.NET
installation, when it was trying to set up the schema or tsnname or
whatever it was doing?


Please refer to the ODP.NET docs for the connection string specifics.
You've to specify the connection string element 'data source' as in:
"data source=myserver;.... "

You should run the Net configuration assistant for configuring
connectivity settings.

FB

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------
Jun 23 '06 #8

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

Similar topics

2
by: Hari Om | last post by:
Cannot connect as Internal Hello, I am using IBM AIX 5.1L box for Oracle 9.2.0.1. I cannot connect as internal to my DB INstance - wonder...
1
by: DAVID | last post by:
Hello, With regards to the Connect dialog on Oracle forms 6i via which we can connect to Oracle database, should we use the same functionality on...
1
by: CM | last post by:
Hi, when i want connect me in my BD with a JSP (with this simple code), this exception is throw. Thank's for ur help Mathieu CODE of my...
4
by: Ellen K. | last post by:
Hi all, Being that so far I didn't get an answer to my below problem on the Oracle newsgroup, I figured it couldn't hurt to try here. While at...
5
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For...
12
by: Mikito Harakiri | last post by:
I wonder if WITH RECURSIVE MaryAncestor(anc,desc) AS ( (SELECT parent as anc, child as desc FROM ParentOf WHERE desc = "Mary") UNION (SELECT...
8
by: danbredy | last post by:
Hi, I'm attempting to connect to an Oracle database using SQL Server 2005 Express (OS is Windows XP Professional) and having absolutely no luck....
6
by: BillCo | last post by:
I've reached the limit of my knowledge here and I'm starting to go mad - any help would be greatfully recieved!!!! I'm having a strange problem...
5
by: mivey4 | last post by:
Hi, First off, I am aware that this is a very heavily documented error and I have done my homework for throughly researching probable causes...
0
by: tammygombez | last post by:
Hey everyone! I've been researching gaming laptops lately, and I must say, they can get pretty expensive. However, I've come across some great...
0
by: concettolabs | last post by:
In today's business world, businesses are increasingly turning to PowerApps to develop custom business applications. PowerApps is a powerful tool...
0
better678
by: better678 | last post by:
Question: Discuss your understanding of the Java platform. Is the statement "Java is interpreted" correct? Answer: Java is an object-oriented...
0
by: Kemmylinns12 | last post by:
Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and...
0
by: CD Tom | last post by:
This happens in runtime 2013 and 2016. When a report is run and then closed a toolbar shows up and the only way to get it to go away is to right...
0
by: Naresh1 | last post by:
What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge...
0
jalbright99669
by: jalbright99669 | last post by:
Am having a bit of a time with URL Rewrite. I need to incorporate http to https redirect with a reverse proxy. I have the URL Rewrite rules made...
2
by: Matthew3360 | last post by:
Hi, I have a python app that i want to be able to get variables from a php page on my webserver. My python app is on my computer. How would I make it...
0
by: AndyPSV | last post by:
HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable...

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.