<% dim cn,rs,driver_name driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True" set cn = server.CreateObject("adodb.connection") cn.open driver_name set rs=server.CreateObject("adodb.recordset") rs.open "select * from table",cn,3,1 do while not rs.eof response.write rs("field") rs.movenext loop %>
Microsoft OLE DB Provider for Oracle (0x80004005) Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
我还是想用OraOLEDB DSN="Provider=OraOLEDB.Oracle.1;Password=herog;Persist Security Info=True;User ID=system;Data Source=gdb" conn.open DSN set rs=server.createobject("adodb.recordset") 出现错误 Error Type: Microsoft OLE DB Service Components (0x80070005) Access is denied. /buspass/data2.asp, line 11
dim cn,rs,driver_name
driver_name="Provider=MSDAORA.1;Password=pass;User ID=user;Data Source=afis;Persist Security Info=True"
set cn = server.CreateObject("adodb.connection")
cn.open driver_name
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from table",cn,3,1
do while not rs.eof
response.write rs("field")
rs.movenext
loop
%>
Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.
你看一看是不是你的ORACLE的客户端 出了什么问题了?
DSN="Provider=OraOLEDB.Oracle.1;Password=herog;Persist Security Info=True;User ID=system;Data Source=gdb"
conn.open DSN
set rs=server.createobject("adodb.recordset")
出现错误
Error Type:
Microsoft OLE DB Service Components (0x80070005)
Access is denied.
/buspass/data2.asp, line 11