The following error is returned when adding or modifying an ODBC datasource on a label in Design32, using an Oracle Database.
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.
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.
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.
- 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.
After completing the steps outlined here, the Error 998 should no longer be returned.
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)
All versions of LLM/LPS
ODBC to Oracle DB.