%META:TOPICPARENT{name="InstallConfigODBC"}%
= Testing ODBC DSNs on Windows, with C++ Demo =

C++ Demo is a simple ODBC-based Interactive SQL processor written, as may be obvious from its name, in C++. The binary executable may be found at --
{{{
<OPENLINK_INSTALLATION_DIRECTORY>\samples\odbc
}}}
As with other sample applications we ship, when source code is available, it may be found alongside the executable.

Be sure to launch the tool appropriate to the Driver and DSN you are testing --

|=<b>Driver/DSN</b>  |=<b>Windows</b>  |=<b>default location</b> |
|  64-bit  |  64-bit    | <code>C:\Program Files\OpenLink Software\UDA\Samples\Odbc\cppdemo.exe</code>  |
|  32-bit  |  64-bit    | <code>C:\Program Files (x86)\OpenLink Software\UDA\Samples\Odbc\cppdemo.exe</code>  |
|  32-bit  |  32-bit    | <code>C:\Program Files\OpenLink Software\UDA\Samples\Odbc\cppdemo.exe</code>  |

# The tool will launch.
%BR%%BR%<img src="%ATTACHURLPATH%/CDEMO1.png" style="wikiautogen"/>%BR%%BR%
# Select menu item **Environment** >> **Open Connection**. The ODBC Driver Manager will present a list of available ODBC DSNs. Select the DSN to which you wish to connect ("Informix 7 on Local" has been selected, below) --
%BR%%BR%<img src="%ATTACHURLPATH%/CDEMO2.png" style="wikiautogen"/>%BR%%BR%
# You will be presented with a Login Dialog.  Enter the user name and password for the target database, and click **Connect** --
%BR%%BR%<img src="%ATTACHURLPATH%/CDEMO3.png" style="wikiautogen"/>%BR%%BR%
# You should now be connected to the chosen data source.  Use the **SQL** >> **Execute SQL** menu item to get the SQL input dialog. Enter any valid SQL statement (see example in screen shot), and click **OK**.
%BR%%BR%<img src="%ATTACHURLPATH%/CDEMO4.png" style="wikiautogen"/>%BR%%BR%
# You will be presented with the results of your query.
%BR%%BR%<img src="%ATTACHURLPATH%/CDEMO5.png" style="wikiautogen"/>%BR%%BR%
# Close the connection by selecting the **Environment** >> **Close Connection** menu item.  Exiting the application through any normal Windows pattern will also close the connection.