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_BIGINT defaults to a SQL_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 SQLGetTypeInfo call has some invalid combinations of values. Modify MetaData forces the driver to modify the result set to match what Access expects.

• About Easysoft

• Contact us
• About us
• Clients
• Blog
• Careers

• Products

• ODBC drivers
• JDBC drivers
• Bridges and gateways
• In development

• Services

• Consultancy
• Training
• Custom development

• Licensing

• Product licenses
• Prices

• Support

• Support home
• Solution wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer area
• Client applications

• Legal

• Privacy statement

© 1993 - 2025 Easysoft Limited. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

•