System. Exception: system. Data. oracleclient requires Oracle client software 8.1.7 or later.

Source: Internet
Author: User

If the client has been installed, this problem occurs again, that is, the permission problem. Google attaches it
========================================================== ==========================================================
Recently, I am working on ASP. NET projects. The database used is Oracle9i. An error occurred while connecting to the database. The following information is displayed:

System. Data. oracleclient requires Oracle client software 8.1.7 or later.

Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information to learn about this error andCodeDetailed information about the cause of the error. Exception details: system. Exception: system. Data. oracleclient requires Oracle client software 8.1.7 or later.

How strange is it that it is later than version 8.1.7? Why not. I can only find the reason for surfing the Internet! Now the NTFS partition is really killing people. It turns out to be a ghost of NTFS partitioning. Just like connecting to the SQL Server database, user permissions are very important and cannot be operated normally without authorization. When the Oracle 9i Release 2 client is installed in the NTFS partition of windows, the Security Authentication Settings are incorrect. As a result, the authenticated users user on the local machine cannot see the contents in the ORACLE_HOME directory. net to authenticated users permission to use system. data. the preceding error is reported when the oracleclient connects to the Oracle database.

To solve the preceding problem, you only need to grant the Authenticated Users group the permission to access the Oracle Home Directory. 1. log on to windows with the Administrator permission. 2. Start the window resource browser to find the ORACLE_HOME directory, such as C: \ oracle \ ora92 3. Right-click the pop-up menu and select the directory Sharing and security (Click properties under win2000) 4. Click the "Security" tab 5. In the group and user name lists, click "Authenticated Users. 6. In the user's permission list, set the "read and run" option box to unselected. 7. Click the "read and run" option box again, set it to the selected status 8. Click the "advanced" button and check whether "Authenticated Users" has the "read and run" permission in the permission project and applies it to "this folder, and subfolders and files ". if not, double-click the folder and make sure that the permission can be applied to the folder and subfolders and files ". this item is very important and you must check it. 9. Click "OK". 10. Restart to make all changes take effect.

========================================================== ============================================
Note, after the permission settings, do not need to restart the machine, directly IIS restart on the line, method, start-run-CMD-IISRESET

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.