Solution "system. Data. oracleclient requires Oracle client software 8.1.7 or later"

When using vs2008 + oracle9 for environment connection to Oracle, The vs development server runs normally, but the IIS server reports an error during debugging and deployment!

IIS server error: system. Data. oracleclient requires Oracle client software 8.1.7 or later.

 

Cause of error:

1. Although it is reported that the Client Version 8.1.7 and later must be installed, it is because the. NET account does not have the permission to access the oracle \ bin folder.

2. Advanced Access Security is provided in the NTFS system of Windows Server 2003/2008 or Windows XP. The FAT32 system may not have this problem.

 

The solution is as follows:

I use Windows Server 2008 as an example. Windows Server 2003 and Windows XP are the same.

1. Open a computer with an Oracle client installed, right-click the installation directory c: \ oracle \ ora90 \ bin, and choose Security tab> Edit> Add.

2. click "search range" and select "ntwork service" in the account shown below-Grant "read and execute" permissions to him (if not, give him full control, this is not safe), the sub-Folder inherits this permission, OK.

3. Open "Server Manager"-"configuration"-"local user and group-" group-"adminisgrators-" to add the network service

4. Restart IIS or enter "iisreset" in "run ".

 

Run the web page in IIS. See, it's done!