Reading PDMS Data Using ADO from a Microsoft Visual Basic Program

Refer to example at C:\AVEVA\SQL Direct 12.0\Samples.

The sample program ADOTEST is a simple example containing an ADO data control and an ADO data grid. A combo-box illustrating use of ADO connection and recordset objects lists the available PDMS tables. Selecting a table displays it in the grid.

This application requires Visual Basic 6. The executable depends on MSVBVM60.DLL which you will have if you have installed Visual Basic 6.

To use ADOTEST:

1. Start the program from within SQL Direct Configuration by highlighting a connection and selecting Connection>Test Connection… (see Specifying PDMS Connection Details). On start up the main screen will look like this:

   

2. Select PDMS>Connect to display the login screen:

   

3. Fill this in for the connection you want to test and the main form will be populated as follows:

   

4. Select a table from the list and then the Table>Query Rows menu option (or you can simply double-click the table). This displays the data in the right hand pane: