Troubleshooting the MS SQL Server JDBC driver

DB Navigator requires a JDBC driver in order to connect to a database and supplies JDBC drivers for various database types. In most cases, the driver is installed and configured automatically during installation of DB Navigator.

If the driver is configured properly, the driver is tagged with a blue icon in the JDBC Drivers preferences page. If the driver is tagged with a red icon, however, the driver is not configured and cannot be loaded to connect to a database. If the JDBC driver is not properly configured, you see an error message when you try the database connection.

To troubleshoot the JDBC driver configuration, begin by verifying that the URL specified in the database's connection profile is correct, and then verify several other driver configuration options. These steps are as follows:

From the Connections view, select the database connection in the Connection Profiles list.
Right-click, and choose Edit Connection Profile.
Check the URL in the Connection Profile dialog.
Note: For the Microsoft SQL Server JDBC Driver (DataDirect), the URL should look similar to
```
jdbc:progress:sqlserver://hostname:port;DatabaseName=name
```
in which port is the port number of the database server and name is the logical database name. If the URL contains an IPv6 address, be sure to include an opening bracket before and a closing bracket after the address; for example, [thehostmachine].
Close the Edit Connection Profile dialog once you confirm that the URL is correct.
Choose Preferences > Window > Progress Databases > DB Navigator > JDBC Drivers to open the JDBC Drivers preferences page.
Select the driver you want to configure from the list, and then choose Edit. The Edit Driver dialog appears.
In the Edit Driver dialog:
1. Ensure the string in the Name field is unique and indicates the correct driver.
2. Ensure the Driver Class Name field is correct. The DataDirect Microsoft SQL Server JDBC Driver class name is as follows: com.prgs.jdbc.sqlserver.SQLServerDriver
3. Click the Extra Class Path tab. Verify that the following pathnames appear:
```
install_dir\oeide\architect\eclipse\plugins\com.progress.dbnavigator_2.1.0\drivers\pgsqlserver.jarinstall_dir\
oeide\architect\eclipse\plugins\com.progress.dbnavigator_2.1.0\
drivers\pgbase.jarinstall_dir\oeide\architect\eclipse\plugins\com.progress.dbnavigator_2.1.0\drivers\pgutil.jar
```
  Note: The install_dir path refers to the complete path of your product installation. You must provide this complete pathname to configure the driver properly.
4. If a required driver is not listed in the Extra Class Path list, click Add.
5. Choose the required driver; repeat for each additional driver required.
6. Use Delete to remove any incorrect pathnames.