An error occurred while connecting ASP. NET to Oracle!

Source: Internet
Author: User
A problem occurred when connecting oracle. My machine is installed with the oracle9.2 client. When when using the data access component (called system, ProgramThe error "system. Exception: system. Data. oracleclient requires Oracle client software version 8.1.7 or greater" is reported. You cannot create an oracleconnection.

A When Oracle 9.2 runs on the NTFS partition, 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. Follow these steps:
1. log on to as 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 "authenticauth" is" this folder "," the folder, "", and apply the Change permissions to the folder;
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.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.