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)