What settings are required to run the ODBC-JDBC Gateway with JDataStore?
| ODBC-JDBC Gateway data source setting | Value |
|---|---|
| Driver Class | com.borland.datastore.jdbc.DataStoreDriver |
| Class Path | jdsserver.jar |
| URL | jdbc:borland:dsremote://host/db where db is full path to a file.jds file. For example, C:\JDataStore7\samples\JDataStore\datastores\employee.jds. |
- For more information about the JDataStore JDBC driver, refer to http://support.embarcadero.com/jdatastore/jdbc.
- Ensure that there are no trailing spaces at the end of the Driver Class field.
- Turn on BigInt Default if your client application is Microsoft Access. Access expects any data type that it does recognise to default to a
SQL_CHAR.SQL_BIGINTdefaults to aSQL_C_BIGINT(as per the ODBC specification). Setting this option forces the JDBC driver to use the "incorrect" mapping that Access expects. - Turn on Modify MetaData when exporting data from Microsoft Access into JDataStore. The result set that JDataStore generates for the
SQLGetTypeInfocall has some invalid combinations of values. Modify MetaData forces the driver to modify the result set to match what Access expects.