Test adapter with Execute Query

After you configure the OLE-DB adapter properties, you can use the Execute Query command option to test the adapter. The Execute Query command executes the SQL Select statement that is in the CommandText sub-property of the SelectCommand property of the adapter.

To use the command option to test an OLE-DB adapter

1. In the Project Explorer, right-click the adapter.

2. Click Execute Query. If the adapter is connected to the source table, the Studio Query Result window appears and displays the retrieved dataset.

   If the adapter is not connected to the table, a message appears to alert you to a situation that requires resolution before you can continue.

   

Related topics

• Use the Project Explorer

• Add and configure an OLE-DB data source

• Add and configure an OLE-DB data connection

• Add and configure an OLE-DB adapter