Connect to Database Using ODBC Page (Database Query Wizard)

Relevant for: GUI tests and scripted GUI components

This wizard enables you to define the query for your checkpoint or output value using Microsoft Query or by manually entering a database connection and SQL statement.

To access
  1. Ensure that a GUI action or component is in focus in the document pane.

  2. Select Design > Checkpoint > Database Checkpoint or Design > Output Value > Database Output Value.

Relevant tasks

Insert a checkpoint step

Wizard map

This wizard contains:

Connect to Database Using ODBC > Specify SQL Statement

See also

Specify SQL Statement Page (Database Query Wizard)

User interface elements are described below:

UI Elements

Description

Create query using Microsoft Query

Opens Microsoft Query, enabling you to create a new query. After you finish defining your query, you return to UFT. This option is available only if you have Microsoft Query installed on your computer.

Specify SQL statement manually

Opens the Specify SQL statement page in the wizard, which enables you to specify the connection string and an SQL statement.

Maximum number of rows

When selected, enables you to limit the number of rows and enter the maximum number of database rows to check or output. You can specify a maximum of 32,000 rows.

Show me how to use Microsoft Query

Displays an instruction page when you click Next before opening Microsoft Query. Available only when Create query using Microsoft Query is selected.