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.

• 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 - 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.

• 
• 
•