On Windows, Microsoft ships an ODBC-enabled application, named ODBC Test, in the ODBC SDK. You can use ODBC Test to test the ODBC client and the ODBC Driver Manager. ODBC 3.51 includes both ANSI- and Unicode-enabled versions of ODBC Test.
To use ODBC Test, you must understand the ODBC API, the C language, and SQL. For more information about ODBC Test, refer to the Microsoft ODBC SDK Guide.
The example and example64 applications are small C applications provided with the ODBC Client on UNIX and Linux platforms. The programs and source files are located in the installdir/example directory, where installdir is the installation directory of the ODBC Client. When you run the executable, you are prompted for the ODBC data source name, user ID, and password. Once connected, a prompt appears. You can then execute any non-parameterized SQL statements.
The example and example64 applications are useful for executing any type of SQL statement, testing database connections and SQL statements, and verifying your database environment.
