You can connect to and work with databases by using methods and properties of the TestComplete ADO and BDE program objects. To learn how to work with these objects, we recommend that you get acquainted with the following examples:

BDE Examples

ADO Examples

CreateADOConnection

CreateADODataset

CreateADOQuery

CreateADOTable

Working With ADO Recordset

Working With ADO Command Object

Connecting to MS SQL Database Using ADO

Note: The ADO object has the following specifics:

It can be used to execute only SQL queries (SELECT, UPDATE, INSERT, etc.), not SQLCMD scripts.
While retrieving Decimal values from a database, it converts them to the Currency type. Since the Currency type has a smaller size than the Decimal type has, an overflow error occurs if a Decimal value being retrieved is large and falls outside of the Currency type’s data range. You may get this error when retrieving large Decimal values (more than 14 significant digits). To avoid the error, you can work with the database by using Microsoft ADO components (see above).

To learn more about other ways of working with databases that are available in TestComplete, see Working With Databases.

Working With Databases Using ADO and BDE Objects

See Also