Server Configuration
The server for the RCI is defined as the Windows machine running an instance of the CONNX RCI/JDBC Server. In order for the Precompiler or the RCI run-time to function, an instance of the RCI/JDBC server service must be running and available. For details on the installation and configuration of the RCI/JDBC server, please refer to the CONNX documentation, available online, on the CONNX CD-ROM, and within the CONNX Adabas SQL Gateway product.
CDD / JDBC Server
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.