To access data from the RCI, the schema definition for the tables referred to in the user's embedded SQL must be defined in a CONNX Data Dictionary (CDD).

For more information on how to import into and configure a CDD please refer to the CONNX documentation, available online, on the CONNX CD-ROM, and within the CONNX application.

Once the CDD has been defined, the CDD must be made available to the RCI/JDBC server by invoking the CONNX DSNRegistry tool to create a logical name, known as a Data Source Name (DSN) that points to the CDD. The CDD DSN should be registered on the same machine on which the CONNX RCI/JDBC Server is installed. The CONNX RCI/JDBC Server checks the Windows registry on that machine to locate the DSNs.

Note: A DSN for use with the RCI is not the same as an ODBC DSN. If you intend to use both ODBC and the RCI to access databases, you must create a DSN for both access methods. A DSN registered for the RCI is also compatible with CONNX JDBC.