Testing a DriverManager connection
You can use DataDirect Test™ to verify your connection. The screen shots in this section were taken on a Windows system.
To test the connection from the driver to your data source, follow these steps:
1. Navigate to the installation directory. The default location is:
Windows systems:
Program Files\Progress\DataDirect\JDBC_60\testforjdbc
UNIX and Linux systems:
/opt/Progress/DataDirect/JDBC_60/testforjdbc
For UNIX/Linux, if you do not have access to /opt , your home directory will be used in its place.
2. From the testforjdbc folder, run the platform-specific tool:
testforjdbc.bat (on Windows systems)
testforjdbc.sh (on UNIX and Linux systems)
The Test for JDBC Tool window appears:
3. Click Press Here to Continue .
The main dialog appears:
4. From the menu bar, select Connection > Connect to DB .
The Select A Database dialog appears:
5. Select the appropriate database template from the Defined Databases field.
6. In the Database field, specify all required connection properties.
For example:
jdbc:datadirect:googlebigquery:Project=myproject;Dataset=mydataset;
7. Click Connect .
If the connection information is entered correctly, the JDBC/Database Output window reports that a connection has been established. (If a connection is not established, the window reports an error.)
Windows systems: Program Files\Progress\DataDirect\JDBC_60\testforjdbc
