What settings are required to run the Easysoft ODBC-JDBC Gateway with JDataStore?

Easysoft ODBC-JDBC Gateway

Attribute	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, see http://support.embarcadero.com/jdatastore/jdbc.
Ensure that there are no trailing spaces at the end of the Driver Class field.
The data source option "BigInt Default" must be ticked when being used in conjunction with Microsoft Access. Access expects any data type that it does not know about to default to a SQL_CHAR. SQL_BIGINT defaults to a SQL_C_BIGINT (as stated in the ODBC specification). Setting this option forces the driver to use the "incorrect" default mapping that Access expects.
The data source option "Modify MetaData" must be ticked when exporting data from Microsoft Access into JDataStore. This is because the result set that is generated by JDataStore for the SQLGetTypeInfo call has some invalid combinations of values. This option will force the driver to modify the result set to match what Access expects.

*	Did this content help you? Yes No Maybe

*	Please select one option based on your first choice: I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

	Suggest new content or let us know how we can improve this content:

	(* Required Fields)