asp用ado联不上oracle？

gyx999 2003-08-29 07:28:35

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
到底是什么问题？
但在delphi中是可以啊！
那个DSN的字符串就是从delphi中copy过来的。

...全文

25 12 打赏收藏转发到动态举报

写回复

用AI写文章

12 条回复

切换为时间正序

请发表友善的回复…

发表回复

Heartyoung 2003-09-10

打赏
举报

我也是这个问题

oo4o你试了吗？

gyx999 2003-09-08

打赏
举报

我还是想用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

Drate 2003-09-02

打赏
举报

呵呵，这个提示是说，你的IIS端没有安装ORACLE 的CLIENT程序呀
你看一看是不是你的ORACLE的客户端出了什么问题了？

gyx999 2003-09-02

打赏
举报

到底是哪里权限的问题啊,请帮我!

gyx999 2003-09-01

打赏
举报

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.

beckhambobo 2003-09-01

打赏
举报

<%
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
%>

gyx999 2003-09-01