以下链接方式是用的ORACLE的专用对像链接方式,移值性不高,但效率挺高的ORACLE专用ODBC 下载
http://otn.oracle.com/software/content.HTML 需注册
default.ASP
-----------------------------------------------------------------
资料库连结测试
connection.ASP
-----------------------------------------------------------------------------
测试结果如下:
<%
On Error Resume Next
'连结资料库
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.DbOpenDatabase( _
Request("Database"),Request("Name")&"/"&Request("Password"),0)
If Err.Number > 0 Then
'判断是否发生错误
Response.Write "
ASP的错误控制
"Response.Write "ASP 的错误来源:" & Err.Source & "
"
Response.Write "ASP 的的错误代码:" & Err.Number & "
"
Response.Write "ASP 的的错误说明:" & Err.Description & "
"
Err.Clear
Response.Write "
Oracle OLE 的错误控制
"Response.write "Oracle OLE的错误代码:" & OraSession.LastServerErr &"
"
Response.write "Oracle OLE的错误说明:" & OraSession.LastServerErrText &"
"
else
Response.write "
资料库成功连结
'关闭资料库
OraDatabase.Close
'Free Session物件
Set OraSession = nothing
End If
%>

