Solution to ASP connection to Oracle database using ADO

Error

----------- Connectionstring:
Provider = oraoledb. Oracle; Data Source = ORACLE; user id = sinodigital; Password = AAAAA;
------------ Err. Description:
Provider cannot be found. It may not be properly installed.
----------- Connectionstring:
Provider = msdaora.1; Password = AAAAA; user id = sinodigital; Data Source = ORACLE; persist Security info = true
------------ Err. Description:
Oracle client and networking components were not found. these components are supplied by Oracle Corporation and are part of the Oracle version 7.3.3 or later client software installation. provider is unable to function until these components are installed.

----------- Connectionstring:
DSN = dl; uid = sinodigital; Pwd = AAAAA; server = ORACLE;
------------ Err. Description:
[Microsoft] [ODBC driver manager] driver's sqlallochandle on SQL _handle_env failed

 

Cause: the authenticated users user permissions in the Oracle installation directory folder are insufficient. As a result, the system cannot access the Oracle directory when creating a database connection to an ASP file.

Solution: oracle9.2 is used as an example.

1. In the Oracle Installation Directory of the web server, right-click and select Properties of the ora92 folder.

2. on the "Security" Page, unselect the "read and run" permission of the authenticated user (For A Long Time) and click "OK ".

3. Open the properties page again, select "read and run" of the authenticated user on the "Security" page, and click "OK ".

If the "Security" page is not displayed, deselect "use simple file sharing (recommended)" under "Tools"> "View" and click "OK.