TestingWindowsADODSNs Test Program for ADO.NET Connections 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 connect string for the Unmanaged "Bridge" ADO.NET Provider -- the Single-Tier ADO.NET Provider for ODBC Data Sources -- is extremely simple. As shown, it simply specifies an ODBC DSN and provides user credentials for the connection --
The connect strings for the 100% Managed ADO.NET Providers -- the Multi-Tier Generic Client ADO.NET Provider; the Single-Tier ADO.NET Provider for Microsoft SQL Server; and the Single-Tier ADO.NET Provider for Sybase -- are more complex, as they must specify every attribute of the connection --
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 --