Solve the problem of being unable to access the Oracle database after ASP.NET is installed. I forgot where I posted this article.
After installing ASP.NET and the Oracle9i client, I received the following message when using System.Data.OracleClient to access the Oracle database.
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
The reason is that
the security authentication settings of the Oracle 9i Release 2 client when installed on the NTFS partition of Windows are incorrect, causing the local Authenticated Users user to be unable to see the contents of the ORACLE_HOME directory; This causes the above error to be reported when ASP.NET uses System.Data.OracleClient to connect to the Oracle database with Authenticated Users permissions.
Solution
To solve the above problem, just add the permission to access the Oracle Home directory to the Authenticated Users group
to
log in to Windows with Administrator permissions.
Start the Window resource browser and find the ORACLE_HOME directory, such as C:Oracleora92
Right-click the pop-up menu and select Sharing and Security of the directory (click Properties under Win2000)
Click the "Security" tab and click the "Authenticated Users" item in the list of group and user names.
In the user's permission list, uncheck the "Read and Run" check box and click the "Read and Run" check box again to set it to checked. Click the "Advanced" button and select the permission item Determine if "Authenticated Users" has "Read and Run" permissions that apply to "This folder, subfolders, and files". If not, double-click it and make sure the permissions "Apply to" "This folder," and subfolders and files". This item is very important and you must check it.
Click the "OK" button to restart for all changes to take effect.
===================================== =============
The 'OraOLEDB.Oracle.1' provider is not registered on the local machine. There are three possible reasons for this situation.
1. Is the machine where Oracle is installed on NTFS? If so, release all the permissions of BIN under Ora81 to all users.
(Otherwise, under the B/S structure, this error will be reported because there is no permission to access the directory)
2. If the database server is Oracle816. Find the sqlnet.ora file under Ora81networkADMIN on the server machine and change the
SQLNET.AUTHENTICATION_SERVICES= (NTS) changed to
SQLNET.AUTHENTICATION_SERVICES= (NONE)
(This will cause some machines to report driver initialization failure errors, which occurred once when using OracleClient)
3. If none of the above solves the problem. You can consider whether the registration in the registry is really lost. (The possibility is relatively small, windows is still relatively safe)
regsvr32 ..ORACLE_HOMEbinOraOLEDB.dll
If it still doesn't work, you can try reinstalling the client.