Re: Oracle 8/ ASP / User Authentication

From: <zeyd_at_my-deja.com>
Date: Fri, 29 Sep 2000 23:52:28 GMT
Message-ID: <8r39vq$pn3$1@nnrp1.deja.com>

In article <8qq1rr$8rn$1_at_soap.pipex.net>, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:
> Hi
>
> my asp code for creating a connection looks like
> <%
> set adoConn = Server.CreateObject("adodb.connection")
> adoConn.ConnectionString = "PROVIDER=MSDAORA.1;DATA SOURCE=<oracle
> service>;USER ID=<uid>;PASSWORD=<pwd>;"
> adoConn.Open
> %>

In my case this results in:
ORA-12203: TNS:unable to connect to destination I can connect using the same uid/pwd in a Microsoft datalink and in ODBC. It's only when using ADODB with ASP that it fails.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 29 2000 - 18:52:28 CDT