Microsoft OLE DB Provider for Oracle error '80004005'

最新推荐文章于 2024-09-03 23:39:09 发布

原创最新推荐文章于 2024-09-03 23:39:09 发布 · 3.7k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #microsoft #permissions #asp.net #security #.net

Asp.net 专栏收录该内容

0 篇文章

订阅专栏

本文记录了解决Oracle 9i与ASP.NET在Win2000 SP4及IIS5.0环境下连接失败的问题过程。通过调整Oracle安装目录的安全权限设置，成功实现了两者的正常连接。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

今天在做项目时发现一个如标题的问题

环境配置:

Win2000 sp4

IIS 5.0

.net framework 1.1

Oracle9i(用OleDb连接)

环境配好后,SQL*PLUS连接没问题.

随便做了个ASP.NET工程,想测试一下和数据库的连接,结果发生错误.记得以前用8i的时候没有错的啊.

没有办法,只好上网去查,终于找到一个和我遇到同样问题的.以下是他的网址

http://www.vbip.com/forum/topic.asp?id=6259

以下是引用:

--------------------------------------------------------------------------------------------------

Go to your ORACLE_HOME folder, D:/Oracle/Ora92 in my case, and pull up its properties. Then head to the security tab and select the Authenticated Users group. The three permissions that should be checked are Read & Execute, List Folder Contents, and Read. Uncheck Read & Execute then RE-Check it again to reset permissions for everything underneath. Just to be safe, go into the ADVANCED settings and make sure that Authenticated Users has "This folder, subfolders and files" under the APPLY TO column. If not, double click on it and change the drop down to say that. It should say this already by now, but just be sure it does!

Reboot and everything should work as advertised ... it finally worked for me.
----------------------------------------------------------------------------------------------------

我按着改了以后,问题解决了.

分析:

感觉是Oracle和.net的权限问题,但是我把ASPNET的权限该为administrator了还不行.

按他说的,好象Oracle里有文件没有被附上读和执行的权限.但具体是哪些文件,不清楚.

有遇到类似问题的朋友可以试着改一下,看看问题能不能解决.