Home » Infrastructure » Windows » connection to oracle 9i from ASP page OS is xp
icon9.gif  connection to oracle 9i from ASP page OS is xp [message #156812] Sat, 28 January 2006 01:45
rampratap
Messages: 50
Registered: November 2004
Location: New Delhi
Member

i am having os xp, oracle 9.2
on same machine i like to connect oracle thorugh DSN or ODBC provider
i created DSN tested the connection it was succesful
even while creating a ASP page with MS Fontpage With new Database ( File DSN). i am able to create with out any error.
but while running on internet explorer i get error (system erorr 5)

2 last i tried on notepade
the code is
<%
dim cn
set cn = Server.CreateObject("ADODB.Conection")
cn.open "DSN=test.dsn;password=test"
response.write "connected"
%>
next i tried
<%
dim cn
cn = Server.CreateObject("ADODB.Connection")
cn.ConnectionString="Provider=ORAOledb.Oracle;User ID=test;Data Source=orcl;Password=test"
%>
next
<%
dim cn
cn = Server.CreateObject("ADODB.Connection")
cn.ConnectionString="Provider=MSDAORA.1;User ID=test;Data Source=orcl;Password=test"
%>
but all these actions failed
can any one suggest me to connect oracle from a HTML page
i have only one system that is only having database and html page

thanks
Previous Topic: Can't start Reports Builder 9i on XP
Next Topic: system ip
Goto Forum:
  


Current Time: Wed Nov 30 05:50:40 CST 2022