Testing OLE DB connections with the Rowset Viewer sample application
- Select Full Connect from the File menu
- Select
OpenLink ODBC Provider for the connection provider
- Choose an ODBC Datasource either by typing the name directly or using the "..." button and selecting Enumerator from the submenu that appears in place of the button.
In the new dialog that appears choose "
OpenLink ODBC Data Source Enumerator" as the data source enumerator and click Connect. A list of ODBC data sources will appear, from which you can choose the one you want. Click OK to confirm.
- Enter the
UserID and Password, and click on OK to connect.
- Once connected, a Command subwindow will appear, into which you can submit SQL statements for test execution against the data source.
Referenced by...