Oracle Connection

[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

[Cor]

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

[Cor]

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

[Paul Clement]

On Wed, 7 Apr 2004 13:40:01 -0500, "Francis Awofeso" <Fr*************@logicacmg.com> wrote:

¤ 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/d...displaylang=en
http://www.able-consulting.com/dotne...ETDataProvider

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

http://www.able-consulting.com/dotne...iderFromOracle

There are also third-party Oracle providers

DataDirect:

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

CoreLab:

http://crlab.com/oranet/
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Paul Clement]

On Wed, 7 Apr 2004 13:40:01 -0500, "Francis Awofeso" <Fr*************@logicacmg.com> wrote:

¤ 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/d...displaylang=en
http://www.able-consulting.com/dotne...ETDataProvider

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

http://www.able-consulting.com/dotne...iderFromOracle

There are also third-party Oracle providers

DataDirect:

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

CoreLab:

http://crlab.com/oranet/
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)