Easysoft.com Documentation Knowledge Base Products  |  Solutions  |  Support  |  Applications  |  Developer  |  Company

---

The Easysoft ODBC-JDBC Gateway lets ODBC-enabled applications and programming languages such as MS Access, MS Excel, Delphi and C++ access hsqldb. To access hsqldb by using the Easysoft ODBC-JDBC Gateway, follow the steps outlined below.

1. Download the Easysoft ODBC-JDBC Gateway for the platform on which your ODBC-enabled application is installed and then install the Easysoft ODBC-JDBC Gateway.

   For installation instructions, see the Easysoft ODBC-JDBC Gateway documentation.

2. Add a Easysoft ODBC-JDBC Gateway data source that connects to the hsqldb JDBC driver.

   Ensure that the values for the following Easysoft ODBC-JDBC Gateway data source settings match those shown in the table.

   Setting	Value
   Driver Class	org.hsqldb.jdbcDriver Ensure that there are no trailing spaces at the end of the Driver Class value.
   Class Path	hsqldb.jar
   URL	jdbc:hsqldb:hsql://<host>[:<port>][/<alias>] where <host> is the IP address or host name of the hsqldb database server. The optional <port> setting is only necessary if the hsqldb server port is different to the default. The optional <alias> setting is an alias that refers to the database you want to connect to. If omitted, a connection is made to the default database instance. For more information about hsqldb URL settings, see the hsqldb documentation.
   With Schema	OFF (Not checked or set to 0) The database does not support two or three part names, so this option should not be enabled.

   For information about other Easysoft ODBC-JDBC Gateway data source settings, see the Easysoft ODBC-JDBC Gateway documentation.

Applies To

• Products
  • Easysoft ODBC-JDBC Gateway
• Databases
  • hsqldb Database Engine