Easysoft ODBC-JDBC Gateway

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

ODBC-JDBC Gateway DSN 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.

Notes

• 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 ODBC-JDBC Gateway setting "BigInt Default" must be checked if your client application is 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 per the ODBC specification). Setting this option forces the JDBC driver to use the "incorrect" default mapping that Access expects.
• The data source option "Modify MetaData" must be checked 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.

Applies To

• Products
  • Easysoft ODBC-JDBC Gateway
• Databases
  • JDataStore

Knowledge Base Feedback

* 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)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• 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 - 2024 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.

• 
• 
• 
•