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

Problem description: Windows XP and Oracle 10 Gb are installed on the server. The server can normally access the Oracle database, but the remote access to the database (using VS 2005, the client is also Oracle10g) prompts "system. data. oracleclient requires Oracle client software 8.1.7 or later ".

After an afternoon and evening, I finally found a solution:

1. Be sure to Disable Windows Firewall;

2. Find the ORACLE_HOME folder (the server side is D: \ oracle ). Right-click, select attribute-security, select "Authenticated Users" in the group or user column, and remove the "read and run" permission from the permission list, then press the application (it is said that this is a bug in Oracle and also exists in 9i). 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 as determined;

3. restart the computer to make the permission settings take effect. (You can also choose not to restart the computer. Run CMD in the running state to open the command window, run the command iisreset, and restart IIS to access the computer normally );

4. If the client is not accessible, restart vs2005 (my client uses vs2005 and its built-in IIS test code.