5.1.Testing an OLEDB Connection
The connection can be tested using the sample application, "Rowset Viewer" as follows:
-
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 and click OK to confirm.
-
Enter the UserID and Password and click on OK to connect.
-
Once connected an "Command" subwindow will appears, into which you can submit SQL for test querying on the data source.