Oracle Connection

  • Thread starter Thread starter Francis Awofeso
  • Start date Start date
F

Francis Awofeso

I am new to .NET and I am trying to connect to Oracle database. Can
someone with this experience please describe the steps or process to connect
to Oracle from .Net. I will appreciate it if anyone can recommend a URL or
book or document that described the process. Thanks in advance

Francis Awofeso
 
Hi Francis,

He is not there today and probably also not tomorrow however normaly Miha
answers all Oracle questions in

microsoft.public.dotnet.framework.adonet

To a direct answer connections stings you find in

www.connectionstrings.com

I hope this helps,

Cor
 
¤ I am new to .NET and I am trying to connect to Oracle database. Can
¤ someone with this experience please describe the steps or process to connect
¤ to Oracle from .Net. I will appreciate it if anyone can recommend a URL or
¤ book or document that described the process. Thanks in advance

You have several options. I will assume that you already have the Oracle client software installed
an configured.

The following options are available, but I would recommend the .NET providers since you're liable to
get better support for the newer versions of Oracle:

Microsoft or Oracle ODBC drivers with the native .NET ODBC library.
Microsoft or Oracle OLEDB drivers with the native .NET OLEDB library.

Microsoft .NET Provider for Oracle. If you have VS 2003 installed, it is available as
System.Data.OracleClient. If VS 2002 is installed you have to download and install the provider:

http://www.microsoft.com/downloads/...29-17DC-45EA-BFB3-076D1C052524&displaylang=en
http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#OracleNETDataProvider

Oracle ODP for .NET. This is Oracle's native .NET provider. It requires the 9i client.

http://www.able-consulting.com/dotnet/adonet/Data_Providers.htm#OracleNETDataProviderFromOracle

There are also third-party Oracle providers

DataDirect:

http://www.datadirect.com/products/dotnet/index.ssp

CoreLab:

http://crlab.com/oranet/


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top