When setting the environment variable, accidentally delete the path of the Oracle environment variable. When setting ODBC, add the DSN data source and the prompt "unable to load the oracle in oradb10g_home2 ODBC driverProgramBecause of system errors.Code998 ". The solution is as follows:
You must use the user in the administrator user group to set up DNS, and then the common user can use the remote database in DNS.
Unable to load the installation routine of the Oracle in oradb10g_home2 ODBC driver, because there is a system error code 998 Solution
Solution 1
Open "my computer"-"Control Panel"-"Administrative Tools"-"Data Source ODBC"-"User DSN ",
Step 1: click "add ".
Step 2: Select "oracle in oradb10g_home2"
Step 3: click the "finish" button and click the "finish" button. An error dialog box is displayed, prompting you that "the installation routine of the Oracle in oradb10g_home2 ODBC driver cannot be loaded, because there is a system error code 998"
Solution:
This is because the Oracle driver cannot be loaded due to an environment variable problem. The solution is to re-Modify the environment variable.
If Oracle is installed in c: \ oracle \ product ...........
First find c: \ oracle \ product \ 10.1.0 \......... \ bin (find it by yourself. My options are c: \ oracle \ product \ 10.1.0 \ db_2 \ bin)
Then add c: \ oracle \ product \ 10.1.0 \ ........ to the environment variable path \......... \ bin (my options are c: \ oracle \ product \ 10.1.0 \ db_2 \ bin)
OK
Solution 2
1. To c: \ oracle \ ora92
2. Select properties. XP needs to remove simple sharing.
3. Remove the "read and execute" permission for "Authenticated Users, application 4. Select the "read and execute" permission for "Authenticated Users" and apply the permission