Accessing Oracle Databses using ASP

From: Ian Steward <isteward_at_mediaone.net>
Date: Sat, 24 Jul 1999 20:30:21 GMT
Message-ID: <xnpm3.253$9C3.60103@typhoon1.rdc-detw.rr.com>

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 Sat Jul 24 1999 - 15:30:21 CDT