Re: Accessing Oracle Databses using ASP

From: Michael Irving <mtirving_at_ix.netcom.com>
Date: Mon, 26 Jul 1999 10:56:42 -0400
Message-ID: <7nhrbb$na6@dfw-ixnews12.ix.netcom.com>

Ian,

It doesn't look like you used a Data Source. When I connect I use this function...

  Function WIConnect()
    ' On Error Resume Next
    WIConnect = false

Set objCONN = Server.CreateObject("ADODB.Connection") objCONN.Open "Data Source=<ODBC dsn>", "<user>", "<password>"

ErrNum = Err.Number
ErrStr = "Open: " & Err.Description

    If ErrNum = 0 Then
      WIConnect = true
    Else

      ' LogError ErrStr
      ErrStr = "Database unavailable"

End If
End Function

Ian Steward wrote in message ...
>I am getting an error 'ORA-12614 TNS:authentication service failed to
>initialize' on Ret=Conn Open statement below. I have read most of the FAQ
on
>this subjecty.My code is below:
>
><html><head>
><title>insbom3.asp</title>
></head><body bgcolor=silver>
><PRE>
>Bill of Material Module Assembly Component List
><% = Date()%>
></PRE>
><%
> set conn = Server.CreateObject("ADODB.Connection")
> Ret=Conn.Open ("MFGDATA2","ixs","faxcover")
>%>
><head>
><title>Sample Code</title>
></head>
><body>
></BODY>
></HTML>
>
>I am using Microsoft Oracle ODBC driver 2.00 and I can connect to my
>database using SQL Easy and therfore my instance is correct. i.e.
>Database Alias manufacturing
>TCP/IP 204.198.48.100
>Database instance ORCL
>
>my id is ixs and password is faxcover to get into this database via NT.
>
>My DNS on the server is 'MFGDATA2' and in the DNS setup I used user name
>ixs and connect_string manufacturing.
>
>What can I be doing wrong ??
>
>
>
Received on Mon Jul 26 1999 - 09:56:42 CDT