skip to main content
Using the driver : Connecting from an application : Connecting using the JDBC Driver Manager : Testing the connection
  

Try DataDirect Drivers Now
Testing the 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:
Test for JDBC Tool landing page
3. Click Press Here to Continue.
The main dialog appears:
Test for JDBC Tool window
4. From the menu bar, select Connection > Connect to DB.
The Select A Database dialog appears:
The Select a Database dialog box
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;
AccessToken=abcdefghi12345678;RefreshToken=wxyz123456789;
ClientID=123abc.apps.googleusercontent.com;ClientSecret=ab123xy
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.)
Connection window
For more information on using DataDirect test, refer to DataDirect Test in the Progress DataDirect for JDBC Drivers Reference.