After installing the Asp.net,oracle9i client, 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.
Reason
The Oracle 9i Release 2 client does not have the correct security authentication settings when installed into the NTFS partition of Windows, causing the Authenticated users user of this machine to not see the contents of the Oracle_home directory; This causes the above error to be connected to the Oracle database using System.Data.OracleClient with Authenticated Users permissions in ASP.
Workaround:
In the Oracle/bin directory, add to the following users/groups to grant full privileges:
ASP.
Administrator
Authenticated Users
and add ASP. NET to the Administrator group, and then restart IIS
The above method is practical,
Online there is a program, probably the same, there are small differences, in fact, do not advocate to add ASP. Administrator, nor the main open too large permissions, but the following method, tried seems not feasible:
Log on to Windows with administrator permissions.
Start Window Explorer to find the Oracle_home directory, such as C:\Oracle\ora92
Right-click the pop-up menu, select the directory to share with security (Win2000)
Click on the "Security" tab
Click the "Authenticated Users" entry in the group and user names list.
In the user's permissions list, leave the Select box for read and run unchecked
Click on the "Read and run" box again to set it to the selected state
Click the "Advanced" button and in the permission entry determine if "Authenticated Users" has "Read and run" permissions and applies to "This folder, and subfolders and files". If not, double-click this and make sure that the permissions are "applied" to the folder, and to subfolders and files. It is very important that you must check.
Click the "OK" button
Restart to allow all changes to take effect.
"System.Exception:System.Data.OracleClient requires Oracle client software version 8.1.7 or greater under Oracle 9.2"
Today, I encountered a problem connecting Oracle, my machine is the Oracle9.2 client, when using the data Access Components in an ASP. NET application (call System.Data.OracleClient), the program " System.Exception:System.Data.OracleClient requires Oracle client software version 8.1.7 or greater "error, Unable to create OracleConnection, but with WINFOM client on the same machine, the database can be accessed normally. Even more strangely, when I deployed an application to a machine with an Oracle 8.17 client installed, I was able to run normally.
Looking for a long, finally figure out why. Originally when ORACLE 9.2 was running on a partition of NTFS, the Oracle_home directory was not visible for some non-administrator groups of users, and the account used by the ASP. NET app under Windows Server 2003 is Netword Service, so you cannot create an Oracle connection, just reset the permissions on the Oracle_home directory. The steps are as follows:
1. Log in with the administrator's user;
2, Find Oracle_home folder (my is C:\oracle\ora92), right click, select Properties-Security, in the group or user bar select "Authenticated Users", in the list of permissions below the "Read and run" permission to remove, and then press the application , re-select the "Read and run" permission, click on the application, select the "Advanced" button under the Permission box, confirm that "authenticated Users" after the application of "This folder, subfolders and Files", press OK to change the permissions to apply to the folder;
3. Restart your computer for permission settings to take effect (please note that this step is important);
4. After logging in, run the ASP. NET application and get the data of Oracle database normally.
"Go" System.Data.OracleClient requires Oracle client software version 8.1.7 or greater