Rowset Viewer Example

This example describes how to connect to a provider, execute a command, and use IOpenRowset. It may be necessary to configure the ODBC data source before connecting to the provider. Use the ODBC Data Source Administrator to create or select a File DSN and supply the UserID and Password as appropriate.

To connect to a provider:

1. Start RowsetViewer.exe.

2. From the File menu, choose Full Connect.

3. Select MSDASQL as the provider and select your ODBC data source for the DataSource parameter.

4. Click OK.

To execute a command:

1. In the top pane of the MDI child window, type a query — for example:

   SELECT * FROM CUSTOMERS
   

2. Click the SQL button on the toolbar to run ICommand::Execute, or open the Command menu, select ICommand, and then click Execute. The ICommandExecute::Execute dialog box appears.

3. Click OK.

To use IOpenRowset:

1. In the top pane of the MDI child window, type the name of a table in your data source. For example, CUSTOMERS.

2. Make sure you are connected to a provider and click the Execute (!) button, or open the Session menu, select IOpenRowset, and then click IOpenRowset::Open Rowset.

See Also

Concepts

Rowset Viewer Sample