Today, when I installed the Oracle9i database on this machine through ASP on a WIN2K SERVER server, I 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][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Or
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Due to system error 5 (Oracle in jxt_user), the specified driver cannot be loaded.
The connection mode is through ODBC. The driver includes 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, it cannot operate normally. After checking, it was found that the %ORACLE_HOME% setting was correct and included in the PATH.
Searching for information in Simplified Chinese on GOOGLE, I found an information saying the following:
"This is actually an error caused by Oracle9i being installed on the NTFS partition of 2000. The main reason is that IIS has insufficient permissions and cannot find the Oracle9i files."
And he also gave a bunch of English abstracts. The answer to the question is: When installing the directory %ORACLE_HOME%, the permissions are set separately. The default is the Administrator group, the SYSTEM group and a group named "Authenticated Users" The group has permissions. He also said this:
------------------------------------------
v. Click on "Authenticated Users" item in the "Name" list (on Windows XP the "Name" list is called "Group or user names").
vi. Uncheck the "Read and Execute" box in the "Permissions" list (on Windows XP the "Permissions" list is called "Permissions for Authenticated Users"). This box will be under the "Allow" column.
vii. Check the "Read and Execute" box. This is the box you just unchecked.
---------------------------------------------
I feel that this English statement is a bit strange. , why do you want to cancel the "read and execute" permissions of the Authenticated Users group? Doesn't it mean that the permissions are not enough?
Continue to search for relevant information on the ORACLE Technology Network and find this information:
--------------------------------------------------
The Microsoft ODBC driver for Oracle is known not to work correctly on a 9.2 Oracle client. You need to use the Oracle ODBC driver if you're using the 9.2 client.
------------------------------------------------
It seems that this is wrong Occurs regardless of the installation configuration of ORACLE. Because the previous test of using JAVA to connect to ORACLE through JDBC was successful.
So I downloaded the latest MDAC2.8, and after installation, restarted the computer, and then tested the original ASP program and found that it had successfully connected to the ORACLE database.
The "permissions" issue mentioned by others earlier does not seem to apply here. hehe.
Attached:
Download address of MDAC2.8: http://www.microsoft.com/downloads/details.aspx?displaylang=zh-cn&FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c