- Created by Unknown User (mwiller), last modified by Russ Foy on Aug 22, 2014
Description
The following error is returned when adding or modifying an ODBC datasource on a label in Design32, using an Oracle Database.
(M1138) Error from ODBC (on Opening database):
Specified driver could not be loaded due to system error 998 (Oracle in OraClient 10g)home1).
Explanation
The system error 998 is an error returned by Oracle.
Common Causes include:
- The ODBC connection is set up using the 64 bit ODBC. Loftware currently is a 32 bit application and requires that the 32 bit ODBC driver be used.
- The Path statement Environmental Variable to Oracle does not match the actual path to Oracle.
- Mismatched case between the path and the Registry Key (for example: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI) for the Driver.
- If the User invoking ODBC doesn't have permission on the %ORACLE_HOME% directory and subdirectories, this error may be thrown. If an Administrator account is being used, verify that the appropriate file system permissions are granted.
Solution
Verify the ODBC version in use, the Path statement in the Environmental Variable is correct, the Registry Key for the ODBC driver is correct, and user permissions are granted to the user.
Requirements
Access to and the ability to modify Enviromental Variable, Registry, or user premissions are required.
How to confirm the settings
Verify ODBC version used:
- From Start\All Programs \Loftware Labeling select Data sources (ODBC).
Loftware has created this shortcut to point to the 32 bit ODBC. Verify that the System DSN is set up.
Check the Path statement in Environmental Variables.
- From the Start menu, right Click on Computer or My Computer (depending on the Operating System).
- Go to Advanaced System Properties and select Environmental Properties.
- From System variables, highlight the Path and click Edit.
- Verify that the value entered for Oracle matches the actual location for the Oracle install.
Verify the registry key for the driver.
- Start\Run\Regedit.exe.
- Browse to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
- If the value is stored in lower case, make the change to UPPER CASE.
Verify the User Permissions:
- Access to the user permission may require contacting the internal IT group.
- Check the file permissions on the Oracle directory by right-clicking on the directory in Windows Explorer and selecting the Security Tab.
- Select the User and then Edit to see the permissions assigned to the user.
Result
After completing the steps outlined here, the Error 998 should no longer be returned.
Related Articles
-
Page:Error M1138 ODBC on Opening Database (Loftware Print Server Family Knowledge Base)
-
Page:ORA-01013: user requested cancel of current operation.- Error When Using an ODBC to Oracle (Loftware Print Server Family Knowledge Base)
-
Page:Checking Permissions On a Network Drive Using the Run Command (Loftware Print Server Family Knowledge Base)
-
Page:(M4728) DCOM Permission Check Failed When Installing WatchDog-NT or the Loftware Print Server (Loftware Print Server Family Knowledge Base)
-
Page:Error M11167 Image Not Found (Loftware Print Server Family Knowledge Base)
Article Number
2014061
Versions
All versions of LLM/LPS
Environment
ODBC to Oracle DB.