ADO Output

Pocket PC Creations can output data to a database, provided that it is accessible via an ADO driver.

To setup an ADO output target, the following steps must be performed:

When the ADO output target is first enabled, a dialog will appear prompting for a database connection string. Consult the relevant database software manual if you are not familiar with this concept, or if you are using Microsoft Access, an option is provided to simply select an existing Access .mdb file.

After the successful selection of a data source, the field mapping dialog will appear. If the data source needs to be reconfigured at any time, it can be modified via the "Database..." button.

In some databases, a list of available tables will appear in the "Table Name" selection. Select the relevant table to store results in, or enter the name of the table manually if need be.

Once a valid table name has been entered, a list of fields in the table appear in the right-most list under "Table Fields". To the left under "Project Fields" is a list of points in the project that can contain data. To create a mapping between a Pocket PC Creations point and a field in the table, first select the point from the left list. The previous mapping, if any, will be selected in the right list. Click on a new field in the right list to change the mapping.

Note the "Guess Mapping" button can be used to attempt to automatically create a mapping between the project and the fields in the table, by matching point names with field names. It will report which points were mapped successfully.

Once OK is pressed, the settings and field mapping will be saved.

Data Pathways and Data Scripting are not available in the Lite Edition.