Relational Queries Using ODBC

The JADE ODBC (Open Database Connectivity) standard driver and thin client driver enable you to use SQL statements to access a relational view of your JADE database. You can use the JADE ODBC drivers with tools that access databases using ODBC (for example, MS Query or Crystal Reports). The JADE ODBC drivers are installed as part of the JADE installation process.

The JADE Relational View wizard enables you to create a relational view of your JADE database. This relational view can include JADE classes, properties, and methods. It can also include user schema-defined (soft) attributes and entities.

To use an ODBC driver, configure an ODBC Data Source (DSN) using the Data Source Administrator. The DSN defines the ODBC driver to use and any driver-specific configuration information. Usually, a DSN specifies a specific database to use. For JADE, this configuration information includes the relational view to use and connection information.

Typically, the query tool allows you to select the DSN to be used when using the ODBC interface. The query tool will retrieve catalog information defining tables and columns and allows you to define the data required. The retrieval of the data is done using a SELECT statement.

The JADE ODBC thin client establishes a TCP/IP connection with a user-defined ODBC server application running in a JADE node. The JADE ODBC standard (fat) client runs as a JADE client node, establishing communication with a JADE database server in the same way as any other JADE standard client.

The JADE ODBC driver is a Core‑level implementation of an ODBC version 3.51 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.

For more details, see the following subsections.