Configuring a JADE ODBC Driver

The JADE ODBC drivers are installed as part of the JADE installation process. The following subsections explain how to configure a JADE ODBC driver.

As the JADE ODBC driver is invoked by third-party applications, it is unlikely that your current working directory will identify the path for the JADE libraries.

If your JADE libraries are not located in your current working directory, the libraries are loaded from the same directory as the JADE ODBC driver. If the libraries are not found in that directory, exception 8327 is raised.

Windows ODBC drivers are run from the directory specified by the following registry values.

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\JADE ODBC Driver\Driver

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\JADE ODBC Driver\Setup

Each data source may also store where to find its driver directly, as follows.

HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\Data-Source\Driver

If the operating system error 126 (ERROR_MOD_NOT_FOUND), error 1157 (ERROR_DLL_NOT_FOUND), or JADE error 8327 (Directory location of the Jade ODBC library in the DSN is not the Jade Install Directory) is raised, check that the ODBC driver has been installed by accessing the Control Panel ODBC applet to determine if the JADE driver is listed on the ODBC Drivers sheet. If not, install the driver by using the JADE installation medium or odbcinst.

If the JADE driver exists but it is listed as Not Marked or it is the incorrect version, the registry settings specified earlier in this section are pointing at the wrong directory and need to be corrected. If the version is correct, check that the directory contains valid JADE library files.