Skip to end of metadata
Go to start of metadata

Description

The following error is returned when adding or modifying an ODBC datasource on a label in Design32, using an Oracle Database.

 

Message

(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:

  1. 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.

  1. From the Start menu, right Click on Computer or My Computer (depending on the Operating System).
  2. Go to Advanaced System Properties and select Environmental Properties.
  3. From System variables,  highlight the Path and click Edit.
  4. Verify that the value entered for Oracle matches the actual location for the Oracle install.
     

Verify the registry key for the driver.

  1. Start\Run\Regedit.exe.
  2. Browse to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI
  3. If the value is stored in lower case, make the change to UPPER CASE.

Verify the User Permissions:

  1. Access to the user permission may require contacting the internal IT group.
  2. Check the file permissions on the Oracle directory by right-clicking on the directory in Windows Explorer and selecting the Security Tab.
  3. 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.

 

 

 

Article Number

 2014061

Versions

 All versions of LLM/LPS

Environment

ODBC to Oracle DB.