There are two methods to connect using DataDirect Test: through a data source or through driver/database selection.
Connecting Using a Data Source
1. From the main Test for JDBC Tool main window menu, select Connection / Connect to DB via Data Source. DataDirect Test displays the Select A Datasource window.
2. Select a data source from the Defined Datasources pane. In the User Name and Password fields, type the required user and password connection properties; then, click Connect. For information about JDBC connection properties, refer to the OpenAccess SDK Client Reference.
3. If the connection was successful, the Connection window appears and displays Connection Established in the JDBC/Database Output scroll box.
Connecting Using Driver/Database Selection
1. From the main Test for JDBC Tool main window menu, select Driver / Register Driver. Test for JDBC prompts you for a JDBC driver name.
2. In the Please Supply a Driver URL field, make sure that a driver is specified (for example, com.ddtek.jdbc.openaccess.OpenAccessDriver). Then, click OK.
If the JDBC driver was registered successfully, the main Test for JDBC Tool window appears with a confirmation in the JDBC/Database Output scroll box.
3. Select Connection / Connect To DB from the main menu. JDBC prompts with a list of default connection URLs.
4. Select one of the default JDBC driver connection URLs. In the Database field, modify the default values of the connection URL appropriately for your environment.
5. In the User Name and Password fields, type the required user and password connection properties; then, click Connect.
6. If the connection was successful, the Connection window appears and displays Connection Established in the JDBC/Database Output scroll box.
