After the Oracle9i client is installed, use system. Data. oracleclient to access the Oracle database. If this error occurs:
System. Data. oracleclient requires Oracle client software version 8.1.7 or greater.
Cause
When the Oracle 9i Release 2 client is installed in the NTFS partition of windows, the Security Authentication Settings are incorrect. As a result, the authenticated users user on the local machine cannot see the contents in the ORACLE_HOME directory. net to authenticated users permission to use system. data. the preceding error is reported when the oracleclient connects to the Oracle database.
Solution:
Add the following users/groups to the Oracle/bin directory and grant full permissions:
Asp.net Machine Account
Administrator
Authenticated Users
Add Asp.net to the Administrator group and restart IIS.
The above method has been practical,
There is also a solution on the Internet, which is similar and slightly different. In fact, we do not advocate adding Asp.net to the Administrator, nor allow excessive permissions. However, in the following method, it seems that it is not feasible to try:
- Log on to Windows as administrator.
- Start the window resource browser to find the ORACLE_HOME directory, such as c: \ oracle \ ora92.
- Right-click the menu and select share and security for the directory (Click properties under win2000)
- Click the "Security" tab
- Click "Authenticated Users" in the group and user name list.
- In the user's permission list, set the "read and run" selection box to unselected.
- Click "read and run" again and set it to the selected status.
- Click "advanced" and in the permission project, determine whether "Authenticated Users" has the "read and run" permission and applies it to "this folder, and subfolders and files ". if not, double-click the folder and make sure that the permission can be applied to the folder and subfolders and files ". this item is very important and you must check it.
- Click OK.
- Restart to make all changes take effect.