Re: Oracle ASP and OLEDB

From: Niall <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 24 Jan 2000 16:02:23 -0000
Message-ID: <86ht1s$iih$1@soap.pipex.net>

Hi
though not using asp I do use vb to connect for an application I use to monitor my oracle instances. this includes the following code

Global adoConn As New Connection
Global strConnect As String
Public Sub connectToDatabase(strUser As String, strPass As String, strSource As String)
With adoConn

.Provider = "OraOLEDB.Oracle"
.ConnectionString = "User ID=" & strUser & ";Password=" & strPass & ";Data Source=" & strSource & ";"

.Open
End With
End Sub

so I create an ado connection object and set the properties shown above. I believe that you should be able to do this with asp as well.

NB this uses the beta oledb driver from oracle not the microsoft one.

then I can call for example

connectToDatabase scott,tiger,exampledb

in my code

This most certainly works with 7.3.4 databases as those are our production platforms
"JMH" <JMH_at_badlands.com> wrote in message news:86a55v$ei4$1_at_bob.news.rcn.net...
> Is anyone workig with Oracle and ASP who uses OLEDB to make
> their db connection? If so could you explain the steps used to make
> the connection to a 7.3.4 instance.
>
> JMH
>
>
Received on Mon Jan 24 2000 - 10:02:23 CST