Configure the database connection

This section describes the procedure to configure the custom properties required to establish a connection to a specific database and its associated data. You can assign static values to these custom properties or link them to attributes or tag names in your application.

Note: The value fields are not case sensitive.

If you are using a non-default port for the SQL Server database, see the SQLData Object help file for configuration information.

To configure the database connection

1. In the Custom Properties pane, select ConfiguredServer.

2. In the Default Value box, type the network name of the computer hosting the database.

3. In the Custom Properties pane, select ConfiguredDatabase.

4. In the Default Value box, type the name of the target database.

5. In the Custom Properties pane, select SQLQuery.

6. In the Default Value box, type the name of the target table, view or query.

To populate the SQLDataGrid, select Runtime, and then select Retrieve.