p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_components thread: Oracle Connectivity


Message #1 by =?iso-8859-1?q?arrun=20rathesh?= <arathesh@y...> on Sat, 15 Jun 2002 04:57:02 +0100 (BST)
Hi,

Can anyone of you tell me how to connect to Oracle 8i
from ASP coding

I have tried with the below coding,please tell whats
wrong in it

<%@ Language=VBScript %>
<%
'CONST connectionstring 
"Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;User ID=tms;Data Source=tms"
'CONST connectionstring = "Provider=MSDAORA.1;User
ID=tms;Data Source=tms;Persist Security Info=False"
CONST connectionstring = "Provider=MSDAORA.1;Persist
Security Info=False;User ID=tms;Data Source=tms"

'CONST adOpenStatic = 3
'CONST adLockOptimistic = 3
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual
Studio 6.0">
</HEAD>
<BODY>
	<%
  Set Con = Server.CreateObject("ADODB.Connection")
  con.Open connectionstring
  mySQL = "SELECT count(Item_code) FROM Item_Mast01"
  SET RS = Con.Execute( mySQL )
%>

</BODY>
</HTML>


and the error:
Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
ORA-12640: Authentication adapter initialization
failed 
/WebScreen/Entry.asp, line 17



=====
M.ARRUN RATHESH
MAARS SOFTWARE
PHONE -91-44-8241902,903(Off)

________________________________________________________________________
Want to sell your car? advertise on Yahoo Autos Classifieds. It's Free!!
       visit http://in.autos.yahoo.com

  Return to Index