IIS System.Data.OracleClient requires Oracle client software 8.1.7 or later. The workaround

There are so many things today, the phone keeps on, but things have to be done on one thing.

When using the VSTS2005/2008+ORACLE9 environment to connect Oracle, the VS Development Server works fine, but the IIS server debugging and deployment will error!

IIS Server error: System.Data.OracleClient requires Oracle client software 8.1.7 or later.

Cause of the error:

1. Although it is reported that you need to install the client 8.1.7 and above, the actual. NET account does not have access to the Oracle\bin folder

2. Advanced access security is provided in the NTFS system on Windows Server 2003/2008, and the FAT32 system may not have this problem.

The solution is as follows:

I use Windows Server 2008 as an example Windows Server 2003 is the same

1. Open the computer with the Oracle client installed, and on the install Directory C:\oracle\ora90\BIN folder, right-click on "Security tab-Edit---" to add.

Requires Oracle client software 8.1.7 or later. "Workaround" name= "image_operate_92031313840889211" alt= "" System.Data.OracleClient requires Oracle client software 8.1.7 or later. "Workaround" src= "http://s11.sinaimg.cn/middle/6d583f964aaee69c823fa&690" width= "690" height= "406" real_src= "/HTTP/ s11.sinaimg.cn/middle/6d583f964aaee69c823fa&690 ">

2. Click "Look in", select "Ntwork SERVICE" in the account shown below----Assign the "Read and execute" permission to him (if not, give him full control, this is not safe), subfolders inherit this permission, OK.

3. Open "Server Manager"-"configuration-Local Users and Groups-" group-"adminisgrators-" Add the network Service in

Requires Oracle client software 8.1.7 or later. "Workaround" alt= "" System.Data.OracleClient requires Oracle client software 8.1.7 or later. "Workaround" src= "http://s9.sinaimg.cn/middle/6d583f964aaee6b3a7888&690" real_src= "http://s9.sinaimg.cn/middle/ 6d583f964aaee6b3a7888&690 ">

4. Restart IIS and enter "IISRESET" in "Run".

IIS System.Data.OracleClient requires Oracle client software 8.1.7 or later. The workaround