473,695 Members | 1,579 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 4359
A.) You've never needed ODP.net, just the Oracle client.
B.) Microsoft has their own managed data provider for Oracle
(System.Data.Or acleClient) 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;Pas sword=passwd;In tegrated
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********@gma il.com> wrote in message
news:11******** *************@r 2g2000cwb.googl egroups.com...
A.) You've never needed ODP.net, just the Oracle client.
B.) Microsoft has their own managed data provider for Oracle
(System.Data.Or acleClient) 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.ht m

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.n l> wrote in message
news:xn******** *******@news.mi crosoft.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.n l> wrote in
message news:xn******** *******@news.mi crosoft.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
21242
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 why? Here is what is do: ------------------------------------------------------------------- $export ORACLE_SID=GATES
1
4801
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 forms run time again? I mean, I want to make a window with three screen items for username, password and service name. And on run time after connecting to the database I use this window to reconnect to an other database. So when I give the appropriate information, I will connect to the
1
10687
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 JSP ---------------------
4
5206
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 my current job I've been working with mostly SQL Server, now I need to connect to our Oracle Financials running on HP-UX. The Oracle DBA set me up as a user and installed the Oracle client on my box and I have the tnsnames file, but I still can't establish a connection to the database from my...
5
13213
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 Oracle, but both not working. For Microsoft ODBC For Oracle approach, I added a data source in Oracle Data Source Administrator, in System DSN tab, I created a system data source named OracleDSN with Microsoft ODBC for Oracle.
12
3728
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 A1.anc, A2.desc FROM MaryAncestor A1, MaryAncestor A2 WHERE A1.desc = A2.anc) ) SELECT anc FROM MaryAncestor
8
14370
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. Here is the information SQL Plus gives me about the database when I log in - Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options
6
17630
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 with making pass through queries to an oracle db with a permament connection string. - if i create the passthrough query by writing the sql into the sql builder window and selecting the connection details on opening the query then everything works fine
5
38829
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 before deciding to post my problem here. At this point, I believe another set of eyes on the issue is merited. I am a MSSQL DBA and somewhat new to ORACLE; but I have read the administrators manual having a basic thorough level of knowledge (Tho' I am still learning) and understanding of how to...
0
8623
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
8565
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9113
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
8839
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
8822
tracyyun
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6488
isladogs
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5837
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
4339
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...
2
2269
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.