To run the query sample program

1. Go to the Windows Program Manager and click the "Query Sample Program" icon in the AcuODBC Sample Programs window. A screen labeled "ODBC Sample Program" displays.

2. In order to open an ODBC connection to the sample data source, select "Connect" from the Login menu. A pop-up window displays.

3. In this window, select "Customer" for the data source (because this name corresponds to the DSN you created), then click "Connect."

4. In the resulting SQL entry field, type the following SQL statement:

select * from CUSTOMER

This queries the CUSTOMER table of the Customer data source.

The tables that are available include: CUSTOMER, ORDERS, ARTICLES, UNITS, and CURRENCY.

The record structure of these files is described in Section 4.2 The Sample Orders Program.

5. To run the query, select "Execute SQL" from the Query menu. The CUSTOMER table displays on screen.

6. To run another query, select "New Query" from the Query menu. Type an SQL statement in the SQL entry field as before, then select "Execute SQL" from the Query menu. You can execute as many SQL queries as you wish.

7. When you have finished work with the Query sample program, select "Disconnect" from the Login menu to close the ODBC connection.

If you have arrived at this point, it means that installation has succeeded and you can begin creating and testing your applications. Chapter 5 describes how to create queries from Windows applications.

If you encountered any problems trying to run the sample, refer to Chapter 8, "Troubleshooting."