The driver installation includes an ODBC application called Example that can be used to connect to a data source and execute SQL.

  1. After you have configured the data source, navigate to the instal_dir\samples\example directory.
  2. Open the application:
    • On Windows, double-click the Example.exe file.
    • On Linux, run the example application.
    A command prompt opens.
  3. Follow the prompts to enter your data source name, user name, and password. If successful, a SQL> prompt appears.
  4. At the prompt, enter SQL statements to test your connection. For example:

    SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES

The results of your query are displayed. If example is unable to connect, the appropriate error message is returned.
Note: Refer to the example.txt file in the example subdirectory for a detailed explanation of how to build and use this application.