%META:TOPICPARENT{name="InstallConfigADONETProviders"}%
= Test Program for ADO.NET Connections=

A simple interactive SQL (iSQL) program is provided to test connections made with our ADO.NET Providers.

==Testing an ADO.NET Provider==

# Select the **radio** button for the ADO.NET Provider you want to test.
# Enter the **connect string** for the target to which the connection is to be made.
#* The [[UnmanagedNETDataProviderConnectionAttributes|connect string for the Unmanaged "Bridge" ADO.NET Provider]] -- the Single-Tier ADO.NET Provider for ODBC Data Sources -- is extremely simple.  As shown, [[UnmanagedNETDataProviderConnectionAttributes|it simply specifies an ODBC DSN and provides user credentials]] for the connection -- %BR%%BR%<img src="%ATTACHURLPATH%/NetGrid2.png" style="wikiautogen"/>%BR%%BR%
#* The connect strings for the 100% Managed ADO.NET Providers -- the [[ManagedGenericMTNETDataProviderConnectionAttributes|Multi-Tier Generic Client ADO.NET Provider]]; the [[ManagedSQLServerNETDataProviderConnectionAttributes|Single-Tier ADO.NET Provider for Microsoft SQL Server]]; and the [[ManagedSybaseNETDataProviderConnectionAttributes|Single-Tier ADO.NET Provider for Sybase]] -- are more complex, as they must specify every attribute of the connection -- %BR%%BR%<img src="%ATTACHURLPATH%/NetGrid1.png" style="wikiautogen"/>%BR%%BR%
# Click the **connect** button.
# Enter a **SQL query** to run against the target, and click the **Execute Query** button.
# The result set will be displayed in the result set pane, as shown --
%BR%%BR%<img src="%ATTACHURLPATH%/NetGrid3.png" style="wikiautogen"/>%BR%%BR%