ODBC

The Java Runtime Environment (JRE) includes a JDBC-ODBC bridge that enables work on ODBC datasources. This driver is stored in rt.jar library in the JRE lib directory and therefore it’s always available in the CLASSPATH.

This kind of approach is suggested only for databases that don’t provide their own JDBC driver, such as Microsoft Access.

Note - This driver has been deprecated and it’s no more available since Java 1.8.

Library:

rt.jar

Value for iscobol.jdbc.driver:

sun.jdbc.odbc.JdbcOdbcDriver

Value for iscobol.jdbc.url:

jdbc:odbc:<ConnectionString>

Where ConnectionString is determined by the ODBC driver you want to interface. A collection of ODBC connection strings is available at the site: http://www.connectionstrings.com.

The following sample url defines a connection string to a Microsoft Access database named test.mdb:

iscobol.jdbc.url=jdbc:odbc:;DRIVER=Microsoft Access Driver (*.mdb);DBQ=test.mdb;