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 |
Suppose I want to use Index value of "WinEdit" in my script .But it is showing None in "Ordinal identifier" value of Testobject Details in the Object Repository.How to enable Ordinal Identifiers to capture the Index value of that particular WinEdit. I have selected "index" and clicked "OK" from Tools-> Object Identification Again I added same WinEdit to the Object repository But I did not get Index value..Please any one help me.How to enable Ordinal indentifiers
General Ques : At What State u start Automating ? means at what stage we start writing QTP scripts ?
can we call runaction in the funcion
Which statement will use for close an action in QTP?
How can you identify the browser and its information using the qtp script?
How the QTP recognize, handle n reports that a error has been handled by it(QTP) when we perform a recovery scenario in our application n in what manner it will display it in resulting window? Plz help me out.
There are some links on the web page,write a script to count and click those links and check the text on the page displayed on clicking the links.
Hi, how can we check or avoid the memory leakage in QTP9.2?
what is meant by "Parameterization technique"?
Waht is User interface and Integration Testing?
Got job with 3 years fake Experience
how qtp will recognise if application is run on many browsers