Troubleshooting JDBC database connections in the tutorials

Connecting to a SQL server using JDBC can result in error messages generated by JDBC. The errors listed below were encountered when creating the tutorials in this manual and are included to help you troubleshoot connection problems.

Note: JDBC errors may be stacked with other warnings and informational text. If errors and messages are stacked, you may need to refer to several lines in the JDBC error response.

Unable to load dll 'JdbcOdbc.dll'

The JdbcOdbc.dll can't be found. Verify that the JdbcOdbc.dll has been installed in a directory that is on your path and that you do not have any older versions of this .DLL file earlier on your path. Normally, this file is installed in JBuilder\java\bin. If it isn't there, it may have been deleted or the jdbc-odbc bridge was not correctly installed. For installation instructions, see Installing and setting up.

java.sql.SQLException: No suitable driver

When connecting to a URL, each registered driver is used to check the specified URL. This error occurs when none indicate support of that URL.

This error can occur when the driver class file for the specified URL cannot be found, for example, sun.jdbc.odbc.JdbcOdbcDriver. Verify that the driver class name is specified correctly and that it was been properly installed.

Another possible cause of this error is an invalid URL. In this case, verify that the URL name is correctly entered.

Data source name not found

The DataSource name that is specified in the application does not match any DataSources set up in your ODBC configuration, for example, during the Local InterBase installation. See Step 6 of Installing Local InterBase for instructions on setting the DataSource name.

Connection failed java.sql.SQLException: [...] unavailable database

The database you have specified is not available. The square brackets contain the name of the driver which you are attempting to use. Check that the server is running and available.