Asp & oracle

[Sral]

Can any one please show me how to connect to an oracle 8i DB with ADO??
Need the connection string...
Do i have to do anyting else before connecting?

Sral

[Paul Clement]

On 26 Feb 2002 01:47:07 -0800, "Sral" <sral@netkom.voh> wrote:

¤
¤ Can any one please show me how to connect to an oracle 8i DB with ADO??
¤ Need the connection string...
¤ Do i have to do anyting else before connecting?
¤
¤ Sral

You need to install and configure the Oracle client prior to connecting to an Oracle database.

Here is a simple connection string which uses the Microsoft Oracle provider for OLEDB:

objConn.Open "PROVIDER=MSDAORA;DATA SOURCE=OracleDB;","userid","password"

The DATA SOURCE argument in this instance is a DSN created (in the Data Sources ODBC Manager Control
Panel applet) to identify the name of your database.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

[Anthony Waung]

There is several ways to do this. A good quick reference guide is:

http://www.able-consulting.com/ADO_Conn.htm

I hope it stays there.

Anthony


"Sral" <sral@netkom.voh> wrote:
>
>Can any one please show me how to connect to an oracle 8i DB with ADO??
>Need the connection string...
>Do i have to do anyting else before connecting?
>
>Sral