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. 9 2391
D
In fact you do it almost the same as with an SQLServer. But there are
differences. The guys who are the most busy with Oracle are in the
newsgroup.
Microsoft.public.dotnet.framework.adonet
Not that you are not welcome here, in this newsgroup are as well some active
dealing with that, but in the newsgroup I showed, are more and there are
AFAIK some changes for 2.0.
Cor
"D. Patrick" <re*****************@thenotreal.com> schreef in bericht
news:A3*******************@tornado.socal.rr.com... 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.
you do not need the oracle ODP.NET, you can use the MS .NET framework one
look in the vs docs help:-
Oracle Databases
Connections
"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.
Hi,
..NET applications can connect to Oracle using:
- Native ADO.NET providers from Microsoft or from Oracle (ODP.NET). Notice
that Microsoft DOES provide a .NET provider for Oracle. The only thing is
that for .NET Framework 1.0 you had to download it from the web, it didn´t
ship with VS for lack of time.
- The ADO.NET Provider for OLEDB with any OLEDB provider for Oracle.
- The ADO.NET Provider for ODBC with any ODBC driver for Oracle.
So, using .NET 2.0. you have to evaluate the Microsoft .NET Framework
Provider for Oracle agains ODP.NET.
In both cases the Oracle client libraries are required. AFAIK, only
DataDirect Technologies provides Oracle drivers/providers that can connect
directly to Oracle using the TNS protocol instead of the client libraries.
About connection strings, etc. refer to the docs of your provider of choice.
Basically Oracle provides name resolution based on file (TNSNAMES.ORA) or
based on server directory. In some cases I think that you can use the server
name or IP and other info instead of the service alias.
--
Best regards,
Carlos J. Quintero
MZ-Tools: Productivity add-ins for Visual Studio
You can code, design and document much faster: http://www.mztools.com
"D. Patrick" <re*****************@thenotreal.com> escribió en el mensaje
news:A3*******************@tornado.socal.rr.com... 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.
On Thu, 22 Jun 2006 23:53:04 GMT, "D. Patrick" <re*****************@thenotreal.com> 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?
It was never required since Microsoft released their own .NET provider for Oracle. Oracle's ODP.NET
provider requires a minimum version of the 9i client.
¤ b) Do you need to download and install other Oracle files, too?
You need to install and configure the Oracle client software.
¤ 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?
Not sure how to answer this question. The information in your connection string will depend upon the
Oracle client software configuration. You can find a few examples at: http://www.connectionstrings.com/
¤ d) Can you refer to the server's IP address in your connection string
¤ instead of the server name?
Oracle uses host names that resolve to an IP address. The host names are specified in the
tnsnames.ora configuration file and used in the connection string.
Paul
~~~~
Microsoft MVP (Visual Basic)
"Paul Clement" <Us***********************@swspectrum.com> wrote in message
news:pi********************************@4ax.com... On Thu, 22 Jun 2006 23:53:04 GMT, "D. Patrick" <re*****************@thenotreal.com> 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?
It was never required since Microsoft released their own .NET provider for Oracle. Oracle's ODP.NET provider requires a minimum version of the 9i client.
¤ b) Do you need to download and install other Oracle files, too?
You need to install and configure the Oracle client software.
¤ 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?
Not sure how to answer this question. The information in your connection string will depend upon the Oracle client software configuration. You can find a few examples at:
http://www.connectionstrings.com/
¤ d) Can you refer to the server's IP address in your connection string ¤ instead of the server name?
Oracle uses host names that resolve to an IP address. The host names are specified in the tnsnames.ora configuration file and used in the connection string.
Paul ~~~~ Microsoft MVP (Visual Basic)
<< [ODP.NET] was never required since Microsoft released their own .NET
provider for Oracle. Oracle's ODP.NET provider requires a minimum version of
the 9i client.>>
Are you saying that I can access Oracle without installing any Oracle
software? That was my goal, but it didn't work. I received an exception
saying I must at least have the Oracle 8.1 client softare installed. I was
using the System.Data.OracleClient classes in framework 1.1. When I
installed ODP.NET, that exception went away, but I still couldn't connect.
It seems that I must have some Oracle software installed (to use the
tnsnames.ora file), right? Although please prove me wrong.
"D. Patrick" <re*****************@thenotreal.com> wrote in message news:xK******************@tornado.socal.rr.com... "Paul Clement" <Us***********************@swspectrum.com> wrote in message news:pi********************************@4ax.com... On Thu, 22 Jun 2006 23:53:04 GMT, "D. Patrick" <re*****************@thenotreal.com> 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?
It was never required since Microsoft released their own .NET provider for Oracle. Oracle's ODP.NET provider requires a minimum version of the 9i client.
¤ b) Do you need to download and install other Oracle files, too?
You need to install and configure the Oracle client software.
¤ 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?
Not sure how to answer this question. The information in your connection string will depend upon the Oracle client software configuration. You can find a few examples at:
http://www.connectionstrings.com/
¤ d) Can you refer to the server's IP address in your connection string ¤ instead of the server name?
Oracle uses host names that resolve to an IP address. The host names are specified in the tnsnames.ora configuration file and used in the connection string.
Paul ~~~~ Microsoft MVP (Visual Basic)
<< [ODP.NET] was never required since Microsoft released their own .NET provider for Oracle. Oracle's ODP.NET provider requires a minimum version of the 9i client.>>
Are you saying that I can access Oracle without installing any Oracle software? That was my goal, but it didn't work. I received an exception saying I must at least have the Oracle 8.1 client softare installed. I was using the System.Data.OracleClient classes in framework 1.1. When I installed ODP.NET, that exception went away, but I still couldn't connect.
It seems that I must have some Oracle software installed (to use the tnsnames.ora file), right? Although please prove me wrong.
In my experience, you will need to install the "Oracle Client Tools" on all PCs that will run your application. Once the Oracle
client tools are installed, you configure the TNSNames.ora file either manually or with the oracle provided SQL*NET configuration
utility. I find that it is better to skip the SQL*NET utility and copy the TNSNames.ora file from a single location and, thus,
insuring that the files are all the same across all PC's. In fact, in many of my apps I copy the current TNSNames file from a
network directory during initialization of the app. That way, any changes to the TNSNames.ora file are automatically distributed to
the local PC's.
I hope this helps.
--
Al Reid
"Al Reid" <ar*****@reidDASHhome.com> wrote in message
news:eM*************@TK2MSFTNGP05.phx.gbl... "D. Patrick" <re*****************@thenotreal.com> wrote in message news:xK******************@tornado.socal.rr.com... "Paul Clement" <Us***********************@swspectrum.com> wrote in message news:pi********************************@4ax.com... > On Thu, 22 Jun 2006 23:53:04 GMT, "D. Patrick" > <re*****************@thenotreal.com> 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? > > It was never required since Microsoft released their own .NET provider > for > Oracle. Oracle's ODP.NET > provider requires a minimum version of the 9i client. > > ¤ b) Do you need to download and install other Oracle files, too? > > You need to install and configure the Oracle client software. > > ¤ 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? > > Not sure how to answer this question. The information in your > connection > string will depend upon the > Oracle client software configuration. You can find a few examples at: > > http://www.connectionstrings.com/ > > ¤ d) Can you refer to the server's IP address in your connection string > ¤ instead of the server name? > > Oracle uses host names that resolve to an IP address. The host names > are > specified in the > tnsnames.ora configuration file and used in the connection string. > > > Paul > ~~~~ > Microsoft MVP (Visual Basic)
<< [ODP.NET] was never required since Microsoft released their own .NET provider for Oracle. Oracle's ODP.NET provider requires a minimum version of the 9i client.>>
Are you saying that I can access Oracle without installing any Oracle software? That was my goal, but it didn't work. I received an exception saying I must at least have the Oracle 8.1 client softare installed. I was using the System.Data.OracleClient classes in framework 1.1. When I installed ODP.NET, that exception went away, but I still couldn't connect.
It seems that I must have some Oracle software installed (to use the tnsnames.ora file), right? Although please prove me wrong.
In my experience, you will need to install the "Oracle Client Tools" on all PCs that will run your application. Once the Oracle client tools are installed, you configure the TNSNames.ora file either manually or with the oracle provided SQL*NET configuration utility. I find that it is better to skip the SQL*NET utility and copy the TNSNames.ora file from a single location and, thus, insuring that the files are all the same across all PC's. In fact, in many of my apps I copy the current TNSNames file from a network directory during initialization of the app. That way, any changes to the TNSNames.ora file are automatically distributed to the local PC's.
I hope this helps.
-- Al Reid
The problem is that the client tools is a 1.3 GB (when unzipped) chunk of
code. It seems so crazy to do all that when I just want simply connectivity
for some simple "SELECT __ FROM TABLE" calls to an oracle database.
"D. Patrick" <re*****************@thenotreal.com> wrote in message news:yx*****************@tornado.socal.rr.com... "Al Reid" <ar*****@reidDASHhome.com> wrote in message news:eM*************@TK2MSFTNGP05.phx.gbl... "D. Patrick" <re*****************@thenotreal.com> wrote in message news:xK******************@tornado.socal.rr.com...
In my experience, you will need to install the "Oracle Client Tools" on all PCs that will run your application. Once the Oracle client tools are installed, you configure the TNSNames.ora file either manually or with the oracle provided SQL*NET configuration utility. I find that it is better to skip the SQL*NET utility and copy the TNSNames.ora file from a single location and, thus, insuring that the files are all the same across all PC's. In fact, in many of my apps I copy the current TNSNames file from a network directory during initialization of the app. That way, any changes to the TNSNames.ora file are automatically distributed to the local PC's.
I hope this helps.
-- Al Reid
The problem is that the client tools is a 1.3 GB (when unzipped) chunk of code. It seems so crazy to do all that when I just want simply connectivity for some simple "SELECT __ FROM TABLE" calls to an oracle database.
Well, as crazy as it may sound, It is required. On my machine, using the Administrative user option, it consumes 325MB.
Application user install is somewhere around 200MB. If you don't want to install Oracle client tools on the PC's then you need to
look into using building an n-tier solution using remoting or web services.
--
Al Reid
On Fri, 23 Jun 2006 15:26:21 GMT, "D. Patrick" <re*****************@thenotreal.com> wrote:
¤
¤ << [ODP.NET] was never required since Microsoft released their own .NET
¤ provider for Oracle. Oracle's ODP.NET provider requires a minimum version of
¤ the 9i client.>>
¤
¤ Are you saying that I can access Oracle without installing any Oracle
¤ software? That was my goal, but it didn't work. I received an exception
¤ saying I must at least have the Oracle 8.1 client softare installed. I was
¤ using the System.Data.OracleClient classes in framework 1.1. When I
¤ installed ODP.NET, that exception went away, but I still couldn't connect.
¤
No, the Oracle client software must be installed and configured. That is, unless you're using a
third-party library such as DataDirect. The ODP.NET library is a separate install.
Paul
~~~~
Microsoft MVP (Visual Basic) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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:...
|
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...
|
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
---------------------
|
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...
|
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...
| |
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...
|
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....
|
by: Francois Stander |
last post by:
Hi,
I am struggeling to connect to an Oracle db 10.2 through vb.net.
Oracle client is installed on my maschine, Oracle.DataAccess in referenced in my app. this is how my code looks like:
Dim...
|
by: Zwoker |
last post by:
Hi all,
I am accessing data from an Oracle database via a connect string.
I got into the situation where I wanted to write my SQL select statement to do a join between a local table sitting in...
|
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,...
|
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...
| |
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...
|
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...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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 ...
| |
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...
| |