Product Information > JADE External Interface Developer’s Reference > Chapter 2 - Using External Interfaces > External Database Coexistence ODBC Requirements under Windows

External Database Coexistence ODBC Requirements under Windows

The Microsoft Data Access Components (MDAC) installed with your Windows operating system is sufficient for external database coexistence.

When running JADE on a 64-bit machine under Windows in 32-bit mode, you must define the DSN by using the 32-bit version of the Microsoft Data Source Administrator (that is, do not use the default 64-bit version).

To run the 32-bit version, execute:

<\windows directory>\SysWOW64\odbcad32.exe

When running JADE on a 64-bit machine, the bit version of the JADE node where the JADE external database code is executed must match the bit version of the external ODBC driver that is being used and the bit version in which the DSN is defined. For example, if accessing Microsoft Access, which supplies only a 32-bit driver, the JADE node must be executing in 32-bit and the DSN must be defined in the 32-bit ODBC Data Source Administrator.