conn.asp:
<%
MM_conn_STRING = "Provider=MSDAORA.1;Password=zdwy;User ID=zdwy;Data Source=bosweb;Persist Security Info=True"
%>other.asp:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/conn.asp" -->
<%
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_conn_STRING
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 3
%>
<%
MM_conn_STRING = "Provider=MSDAORA.1;Password=zdwy;User ID=zdwy;Data Source=bosweb;Persist Security Info=True"
%>other.asp:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/conn.asp" -->
<%
set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_conn_STRING
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 3
%>
还是出现这个提示,我得本机上安装了oracle9i服务器了
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set WebOraDatabase = OraSession.DbOpenDatabase("sid","user/pwd",0)
sSql = "select * from table"
Set OraDynaset = WebOraDatabase.DbCreateDynaset(sSql,0)
%>
"Provider=MSDAORA.1;Password=name;User ID=name;Data Source=oradb;Persist Security Info=True"
Microsoft VBScript 运行时错误 错误 '800a01ad' ActiveX 部件不能创建对象: 'OracleInProcServer.XOraSession' to beckhambobo(beckham)
Microsoft OLE DB Provider for Oracle 错误 '80004005' 未找到 Oracle 客户端和网络组件。这些组件是由 Oracle 公司提供的,是 Oracle 8i 版 (或更高) 客户软件安装的一部分。 在安装这些组件之前,将无法使用此提供程序。
大侠们,赶快想想办法啊。
<%
Dim HjConnDb,HjStrConn' 連接 Oracle 資料庫 利用Ole Db
Function HjConn_Ora(HjSvr_Name,HjDb_Uid,HjDb_Pwd)
Set HjConnDb=Server.CreateObject("ADODB.CONNECTION")
HjStrConn="Provider=MSDataShape;Data Provider=msdaora; Data Source="
HjStrConn=HjStrConn & HjSvr_Name & "; User Id="
HjStrConn=HjStrConn & HjDb_Uid & "; Password="
HjStrConn=HjStrConn & HjDb_Pwd
HjConnDb.Open HjStrConn ' 打開記錄集示例
' HjStrSql="select * from table_name"
' Set HjRsDb=Server.CreateObject("ADODB.RECORDSET")
' HjRsDb.Open HjStrSql,HjConnDb
End Function
%>//a.asp
<!-- #include file="../../../Public/HjConnDb.asp" -->
HjConn_Ora "web","name","password"