Working With Databases by Using ADO - Examples

Applies to TestComplete 15.47, last modified on January 20, 2023

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

In This Section

Notes:

  • The ADO object can be used to execute only SQL queries (SELECT, UPDATE, INSERT, etc.), not SQLCMD scripts.

  • While retrieving Decimal values from a database, the ADO object 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.

See Also

Working With Databases
Using ADO Components
ADO Object

Highlight search results