<form method= "POST" action= "connection.asp" >
<p> database name: <input type= "text" name= "database" size= "></p>"
<p> User name: <input type= "text" name= "name" size= "></p>
<p> user password: <input type= "password" name= "password" size= "></p>"
<p><input type= "Submit" value= "OK" > <input type= "reset" value= "Cancel" ></p>
</form>
</body>
Connection.asp
-----------------------------------------------------------------------------
<meta http-equiv= "Content-type" content= "text/html; Charset=big5 ">
<title> Database Link Results </title>
<body>
<p> test results are as follows:</p>
<%
On Error Resume Next
' Link Database
Set orasession = CreateObject ("Oracleinprocserver.xorasession")
Set Oradatabase = Orasession.dbopendatabase (_
Request ("Database"), Request ("Name") & "/" &request ("Password"), 0)
If err.number > 0 Then
' Determine if there is an error
Response.Write "Response.Write "ASP Error Source:" & Err.Source & "<BR>"
Response.Write "ASP's error code:" & Err.Number & "<BR>"
Response.Write "ASP's error Description:" & Err.Description & "<BR>"
Err.Clear
Response.Write "Response.Write "Oracle OLE error code:" & Orasession.lastservererr & "<BR>"
Response.Write "Oracle OLE error Description:" & Orasession.lastservererrtext & "<BR>"
Else
Response.Write "<center><H3> Database successful link </center>"
' Close the Repository
Oradatabase.close
' Free Session Object
Set orasession = Nothing
End If
%>
</body>
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
