.net程序无法连接oracle9.2.0.1数据库解决方法

Oracle错误类型：无法加载oci.dll——异常详细信息: System.DllNotFoundException: 无法加载 DLL (oci.dll)

原因：oracle9201如果装在NTFS的系统分区上，会出现此问题

解决方法——在ora92目录的安全性里的权限将ASPNET用户添加上即可，无须重启

1.这个问题的症结在于权限的设置,其解决方案主要是将oracle/oracle92的读写权限赋予asp.net或者是IUSER_..和IWAM_...

  When you install your oracle Client (whatever it might be) make sure to install the Administrator option. In 9.2.0.1.0,it was about 500 MB,This installs all the correct files you need,including oci.dll. This should be similar for most oracle client version.

 

 After it is done,give iuser/iwam these permissions on Oracle(For example, it was d:/Oracle/,)

  * Read & Execute

  * List Folder Contents

  * Read

 

Restart Your Computer

 

 2. 打开Oracle/Ora92 的-〉属性-〉安全 ，选Authenticated_Users, 将Read and Execute 的勾去掉，然后又勾上，Restart your computer;

 

 3. 打开在IIS中的WEB属性--主目录--执行权限 改为脚本和可执行