ODBC Requirements for External Database Coexistence or JADE ODBC Driver Usage

The Microsoft Data Access Components (MDAC) installed with the Windows operating system are sufficient for running an external relational database or using the JADE ODBC standard or thin client driver.

The JADE ODBC drivers are available in 32-bit and 64-bit versions. If running on a 64‑bit machine, the driver used must match the third-party tool being used; for example, it may be necessary to install 32‑bit JADE ODBC drivers for use with 32-bit tools.

When using an external database on a 64-bit machine, the bit version of the JADE node executing the external database access must match the bit version of the external database ODBC driver that is being used.

If you are running JADE on a 64-bit machine under Windows in 64-bit mode and you are configuring a 32‑bit ODBC driver, run the following program:

<\windows-directory>\SysWOW64\odbcad32.exe

This runs the 32-bit version of the Microsoft Data Source Administrator program rather than the 64-bit version.

For more details, see "Configuring a JADE ODBC Driver", in Chapter 2 of the JADE External Interface Developer's Reference.