A good program suddenly encountered an error because: System. Data. OracleClient requires Oracle client software version 8.1.7 or greater, very strange
Oracle on the server is clearly 10 Gb, and no error is prompted 8.1.7 when a program error occurs. Baidu has discovered the following solutions:
When Oracle 9.2 runs on NTFS partitions, the ORACLE_HOME directory is invisible to some non-administrator groups, in windows server 2003, the account used by the asp.net application is netword service. Therefore, you cannot create an oracle connection. You only need to reset the permission of the ORACLE_HOME directory. The procedure is as follows:
1. Log on as an administrator;
2. Find the ORACLE_HOME folder (my name is c: \ oracle \ ora92), right-click it, select attribute-security, and select "Authenticated Users" in the group or user bar ", in the following permission list, remove the "read and run" permission, and then press the application. Re-select the "read and run" permission and click the application; select the "advanced" button under the permission box, confirm that the application following "Authenticated Users" is "this folder, subfolders, and files", and apply the permission changes to this folder according to OK;
3. restart the computer to make the permission settings take effect (this step is important );
4. log on and run the asp.net application to obtain data from the Oracle database. When I saw this, I remembered it. So I looked at the oracle path in the environment variable and found that it was like this. It turns out that on the server a few days ago, I suddenly found that there are two hard disks, which have never been used, and the drive letter has not been split. The drive is on the d disk, and oracle is on the E disk. Looking at the awkwardness, I changed the optical drive to the last, set it to H, and the E disk to D. The two newly added hard disks are E and F.
The hard disk drive letter has been adjusted, but the path in the environment variable has not changed. The path of oracle is still on the E disk, so there is no way to restore the hard disk drive letter to the previous one. The problem is solved.