Easysoft ODBC-JDBC Gateway

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

ODBC JDBC Gateway DSN Setting	Value
Driver Class	com.pointbase.jdbc.jdbcUniversalDriver
Class Path	pbclient43.jar
URL	jdbc:pointbase:server://host/db

Notes

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

Applies To

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

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.

• 
• 
• 
•