how do you do database testing in qtp
Answers were Sorted based on User's Feedback
Answer / aryan
we use database checkpoints to do database testing in qtp.
database checkpoints in a test ensure that the application
successfully retrieves or inserts data into a database.
| Is This Answer Correct ? | 16 Yes | 2 No |
Answer / nani4urs
Wn we have to do database testing in qtp
first we need to create ODBC Connection using DSN.
then we need to write some commands.
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / rajiv.m
In QTP, Database testing is done by inserting Database
Checkpoint. Here we can check database available in any
format like Excel, Access, SQL.... First we need to create
ODBC Connection using DSN and then we need to write some
commands. Here are some commands which are useful for
database testing. <a
href="http://www.1keydata.com/sql/sql-commands.html">SQL
Commands</a>
| Is This Answer Correct ? | 8 Yes | 3 No |
Database Testing means checking the Database informations
is available in the customer requirement or not.
Some cases DB administrators might replaces the columns or
changes some information inthe database.
Database Checkpoints is used to Test Databases.
Here we can check database available in any format like
EXcel, Access, SQL.... QTP will provide you a drivers to
connect with that and download the Data from DB. You should
be the some what familiar with the SQL Queries.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / fayaz khan
While DataBase Testing time first we get the "Data Base Design information" From developers,Here we get the information like
->Names Of the table and there columns names
->Connection Strings(DNS)
->Mapping b/w screens & Tables..
After that we connect to the Database through ADODB.And retrive the data for testing
Adodb is a vb script object to connect to database..
Anybody want to more information about database testing through QTP Please leave a mail to me ....fayazkhan505@gmail.com..
| Is This Answer Correct ? | 3 Yes | 0 No |
w is fragmentation and paging
We have an action attached with the library file in QTP. When I will click on run button,which file is going to be executed first a)Action b)Library
How do you create a library file
How can I replace all the text from the QTP script with some other text. Is there any replace all function in QTP Any one can help me
I used Child objects to get the count of the no of weblist present in the page.now i need to select the item in the weblist..Please send me full code
How to replay a script in qtp?
Tell me the difference between QTP9.2, QTP9.5 and QTP10.0
when will you do debug your script? and explain that process?
How to handle exception when data table is not available in local host system or path is not correct(explain statement with example)
Kindly help me with the following queries.. -- How to recognize webtable using QTP and how to use it? -- How would one conclude that it is a web table -- For Example, if there is a web table and I am clicking on say Cell A1, how would i know that i've clicked on cell A1 -- Kindly suggest me to use the web table better
for a test in QTP i had choose the object repository as shared.after completion of some days i want to conduct the same test again,now the question is HOW TO LOAD THE OBJECT REPOSITORY. is it possible by descriptive programming.could any one tell me how many ways we load it and what is the process?
Explain different types of action in qtp?