Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Accessing Oracle Databses using ASP
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
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