Unable to open connection to "Oracle, Microsoft provider v1.0.5000.0 ″

Run Asp.netProgramWhen you use ibatis to connect to the database, the title is incorrect.

When you view the detailed error, you will find that the Oracle client software 8.1.7 is required.
At first, I found that Oracle had to be re-installed, So I re-installed the server, but I encountered another problem where OCI. dll could not be loaded. Later, it was found that OCI. dll still exists because the folder directory was not deleted after the previous Oracle client was uninstalled.
After the Oracle directory is deleted, the installation is successful.
Oracle client software 8.1.7 is required. It is found on the internet that when Oracle 9.2 runs on NTFS partitions, the ORACLE_HOME directory is invisible to some users not in the Administrators group, in Windows Server 2003, the account of the Asp.net application is network service, so you cannot create an oracle connection. Solution: 1. Log on as an administrator. 2. Find the ORACLE_HOME folder (D: \ oracle \ ora92), right-click it, select Properties-security, and select "Authenticated Users" in the group or user bar ", remove the "read and run" permission from the permission and then apply the permission. Then select the application again. Select "advanced", confirm that "Authenticated Users" applies to "this folder, subfolders, and files", then confirm 3 restart IIS, start -- run -- cmd, and enter iisreset on the console