Testing the Connection
The driver installation includes an ODBC application called Example that can be used to connect to a data source and execute SQL.
To run the Example program:
1. After you have configured the data source, navigate to the installation_directory\samples\example directory.
2. Double-click the Example.exe file. 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 INFORMATON_SCHEMA.SYSTEM_TABLES
The results of your query are displayed. If example is unable to connect, the appropriate error message is returned.