1. From the main Test for JDBC Tool window menu, select Driver / Register Driver. DataDirect Test prompts for a JDBC driver name.
2. In the Please Supply a Driver URL field, specify a driver (for example com.ddtek.jdbc.sqlserver.SQLServerDriver); then, click OK.
If the 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 Test for JDBC Tool menu. The Select A Database window prompts with a list of default connection URLs.
4. Select one of the default driver connection URLs. In the Database field, modify the default values of the connection URL appropriately for your environment.
Note: There are two entries for DB2: one with locationName and another with databaseName. If you are connecting to DB2 for Linux/UNIX/Windows, select the entry containing databaseName. If you are connecting to DB2 for z/OS or DB2 for i, select the entry containing locationName.
5. In the User Name and Password fields, type the values for the User and Password connection properties; then, click Connect. For information about JDBC connection properties, Refer to the appropriate driver chapter in the DataDirect Connect Series for JDBC User’s Guide.
6. If the connection was successful, the Connection window appears and shows the Connection Established message in the JDBC/Database Output scroll box.