skip to main content
Getting started : Connecting using the DriverManager : Testing the connection
  

Try DataDirect Drivers Now

Testing the connection

You can also use DataDirect Test™ to establish and test a DriverManager connection. The screen shots in this section were taken on a Windows system.
Take the following steps to establish a connection.
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 the base URL of the Oracle Sales Cloud site to which you are connecting.
The base URL replaces servername in the sample string. For example:
jdbc:datadirect:oraclesalescloud://mysite.custhelp.com
7. If you are using user ID/password authentication, enter your user ID and password in the corresponding fields.
8. 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 about using DataDirect Test, see DataDirect Test.