The SQL Query object executes an SQL statement during test execution using either an SQL Server or ODBC connection.
To configure the object:
Select the connection type
In the SQL Connection Type property, choose one of the following:- SQL Server — to connect to a Microsoft SQL Server.
- ODBC — to connect to a 64-bit ODBC data source.
Enter the connection string
In the Connection String property, provide the appropriate connection string for the selected connection type.Enter the SQL query
In the Query property, specify the SQL query to be executed during the test run.
Properties:
| Name | Description |
|---|---|
| SQL connection type | The SQL server connects to an SQL server. Select ODBC to connect to an ODBC data source. |
| Connection string | (Required) The SQL Server or ODBC connection string |
| Query | The SQL query |
Overview
Content Tools
