Microsoft OLE DB Provider for Oracle error '80004005'

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

环境配置:

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里有文件没有被附上读和执行的权限.但具体是哪些文件,不清楚.

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