What settings are required to run the ODBC-JDBC Gateway with PointBase?
| ODBC JDBC Gateway data source setting | Value |
|---|---|
| Driver Class | com.pointbase.jdbc.jdbcUniversalDriver |
| Class Path | pbclient43.jar |
| URL | jdbc:pointbase:server://host/db |
- Ensure that there are no trailing spaces left at the end of the Driver Class field.
- The data source option Single Statement must be checked.
- The data source option With Schema must be unchecked when linking tables from Microsoft Access.
- The data source option With Schema must be checked when importing data into Microsoft Excel by using Microsoft Query. This seems to be a bug in Query. It does not provide a list of tables, unless there is a schema returned from the metadata calls. Alternatively, in the Query options dialog, select System Tables.
- The data source option Modify MetaData must be checked when exporting data from Microsoft Access into PointBase.