When IIS accesses the Web, system. Data. oracleclient requires Oracle client software 8.1.7 or later. Solution.

When vs. net2005 + oracle9.2 is used for development, you can click the page in vs to view it in the browser. Everything works normally, but you cannot access the database on IIS,

Tip: system. Data. oracleclient requires Oracle client software 8.1.7 or later.

 

The problem is mainly because oracle is installed under the NTFS directory of Windows2003 and permissions need to be assigned to the Oracle directory. After searching online, most of them say that authenticated users is added, the advanced settings allow the permissions inherited by the parent item to spread the object and all sub-objects. However, I found that the problem persists.

Next, I found that the network service user was to be added, and I tried to find that there was still no change. I can only say that the above solutions can only vary from person to person, maybe it can solve people's problems, but it cannot solve my problems. I have to try again.

In general, this is the permission issue. IIS has the permission to access the Oracle directory, later, in Vs, the web server that runs after checking in the browser is run as administrator in the task manager, and the IIS process w3wp is run as a network service user, if the network service user wants to access the Oracle directory, should he add the network service to the aministrators user group? In the experiment, check the local user and group, select the Administrators group, right-click the attribute, add a user, add the network service to the Administrators group, restart IIS, and access the Web. Haha, I'm happy. Recorded by the way. It may be useful to everyone.