Troubleshoot problems with ASP's inability to connect to ORACLE 9i databases

Source: Internet
Author: User
Tags driver manager connect odbc ole client oracle database
oracle| Solution | data | database | Problem today, on a Win2K server, an ASP installed on the native Oracle9i database found an error and could not connect to the database at all. The error description is as follows:

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
[Microsoft] Sqlallochandle on sql_handle_env of the ODBC Driver manager driver failed

Or

Microsoft OLE DB Provider for ODBC Drivers error ' 80004005 '
The specified driver could not be loaded due to system error 5 (Oracle in Jxt_user)

The connection is through ODBC, and the driver includes the Oracle ODBC Driver and Microsoft ODBC Driver for Oracle.
The connection string is as follows:
(1) CONNECTIONSTRING = "DSN=TXLTNS;" Uid=user; Pwd=password "
(2) CONNECTIONSTRING = "driver={oracle in Txl_user}"; Uid=user; pwd=password;dbq=txltns;dba=w; "

As a result, they are not functioning properly. The check found that the%oracle_home% settings were correct and included in the path.


In GOOGLE search for Simplified Chinese information, found a message saying as follows:
"This is actually an error caused by the oracle9i mounted on an NTFS partition of 2000. The main problem is that IIS does not have sufficient permissions to find errors caused by oracle9i files. ”
And he also gave a bunch of English abstracts, the answer is:%oracle_home% This directory is installed, the permissions are set separately, by default, the Administrators group, the system group, and a group named "Authenticated Users" have permissions. He also said to do this:
------------------------------------------
V. Click on ' Authenticated Users ' item in the ' Name ' list (on Windows XP, "name" list is called "Group or user Names").
Vi. uncheck the "Read and Execute" box in the "Permissions" list (on Windows XP "Permissions" "list is called" Permissi ONS for authenticated Users "). This box would be under the "Allow" column.
Vii. Check the "Read and Execute" box. This is the box for you just unchecked.
------------------------------------------

It is a bit strange to feel this English saying, why do you want to cancel the read and execute permission for the Authenticated Users group, not to say that there is not enough authority?

Continue to query the Oracle Technology network for relevant information and find this information:
-------------------------------------------
The Microsoft ODBC driver for Oracle are known not to work correctly on a 9.2 Oracle client. You are need to use the Oracle ODBC driver if ' re using the 9.2 client.
-------------------------------------------

In this case, this error has nothing to do with Oracle's installation configuration. Because it has been tested before using Java to connect Oracle through JDBC is a success.

So download the latest MDAC2.8, after installation, restart the computer, and then test the original ASP program, found that the Oracle database has been successfully connected.

The question of "permission" mentioned by others seems to be not adapted here. Oh.

Report:
MDAC2.8 's download Address: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID= 6c050fe3-c795-4b7d-b037-185d0506396c



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.