Running the CONNX JDBC Sample Application
To connect to the data source:
1. Enter the required information in the Connection group box in the Query Test Application window.
a. Gateway: The local server TCP/IP address or host name (for example, 127.0.0.1).
b. DSN (Data Source Name): The data source name as registered with the DSNRegistry tool on the CONNX JDBC Server machine. When CONNX is installed, the CDD DSN connxSamples is automatically created and registered to enable access to the CONNX8Sample database. The DSNRegistry tool is described in
To add a new data source name for the JDBC Driver.
c. User ID: CONNX user name (for example, NickD).
d. Password: CONNX password (appears as ********).
e. Application: Database connection option (for example, Oracle or RMS). Database connection options are described in CONNX System Requirements. The Application text box may be left blank if all servers are running that contain the databases listed in the CONNX Data Dictionary. If any of the servers are down, or if the server running the application specified in the Application text box is down, the connection times out.
f. Port: The port number (default is 7500).
2. Click Connect.
After the connection to the data source is established, the Disconnect button in the Connection group box and the Query and Clear Query buttons in the SQL Statement from Keyboard group box are activated.