Testing the Installation

After the Local ODBC Client is installed, you should test basic operations before writing any code to create an IP. Use the installed Local ODBC Client to connect to a default data source and issue test queries.

Note: This section uses the default service names. The service names for your installation will be different if you changed them during installation.

The installation sets up a server data source called Default.

If you are using the OpenAccess SDK SQL engine, the Default server data source is used with one of the following services:

• OpenAccessSDK810_C
• OpenAccessSDK810_Java
• OpenAccessSDK810_NET

The Default server data source is configured to access CSV files that contain tables EMP, DEPT, and DIVISION. The CSV files are part of the SDK installation. The SDK also includes samples that can be used for experimenting, or as a starting point for creating a new IP. See the language-specific OpenAccess SDK Reference for information on building and configuring these examples.

If you are using a third-party SQL engine, the Default server data source is used with one of the following services:

• The OpenAccessSDK810_C_SQL service is partially set up to access a SQL data source through an ODBC driver.
• The OpenAccessSDK810_Java_SQL service is partially set up to access a SQL data source through a JDBC driver.

See the language-specific OpenAccess SDK Reference for information on building and configuring these examples.