Although QTP doesn’t carry any built-in function for database connectivity, testers uses VBScript language to connect and interact with databases using ADODB objects.
ADODB objects are divided into four different properties/methods which helps in successfully creating a database connection,
Connection : Useful in forming a connection with a Database
Command : Useful in executing a SQL command(Queries/Stored Procedures)
Fields : Useful in retrieving a particular column from a record-set after executing a Query/Stored Procedure.
Recordset : Used to retrieve data from a database
