 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
