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
