how do you do database testing in qtp

Answers were Sorted based on User's Feedback



how do you do database testing in qtp..

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

how do you do database testing in qtp..

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

how do you do database testing in qtp..

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

how do you do database testing in qtp..

Answer / baba

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

how do you do database testing in qtp..

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

Post New Answer

More QTP Interview Questions

How to test menu options using qtp

2 Answers  


Who uses qtp tool?

0 Answers  


I install .Net Add-Ins in my system. It installed properly. But all the objects are recognizing as window objects only. But it has to recognize as swf objects. In Record and Run setting i selected 'Record and run test on any open browser' and Record and run test on any open Windows-based application' Can any one tell what setting i have to do to recognize objects correctly as swf...? Please give some suggestions..?

1 Answers  


anyone can explain about "Hybrid framework" in QTP

5 Answers  


Hi, I want to pass a value in to Link object. For ex: I have a link where in which contains the value like "DC4463219(Active)". Whenever i will execute the script this value "DC4463219 (Active)" will get changed. I got the value DC4463219(Active) from the link and stored that value in variable "ACTUAL". If i want to select the same link again, while recording the value DC4463219(Active) will be recorded in object repository. So, that it will not work for the next cycle of execution as the value will get changed everytime as i mentioned above. I want to pass that Acutal value in to link object. The script is as follows: Actual Script when recording: Browser("Web Login").Page("Application").Frame ("ScopeFrame").Link(DC4463219(Active)".Click But now instead of this DC4463219(Active) i want to pass a variable where i have the same value. I tried to execute the script Browser("Web Login").Page("Application").Frame ("ScopeFrame").Link(Actual).Click But it is displaying the error message as that the value which we got from Actual is not existing in Object repository. So,i made the link object as regular expression. Even it is displaying the same message as mentioned above. If you are not able to understand, feel free to contact me with nbabu11@gmail.com

1 Answers  






give the code to count child objects (Total) in the page

1 Answers  


There is web page with the webtable,this contains some data, how do you manipulate the data.

2 Answers   Tech Mahindra,


Plz explain about Virtual object? What is the situation u r using , explain with example?

1 Answers  


What are Add-ins availble in licensed version QTP8.2

1 Answers   TCS,


How to identify 2 versions of browsers based on regular expression

1 Answers   Cognizant,


Hi all , I have installed the QTP 11.0 Whenever I am opening QTP that time if any open Internet Explorer I was getting message (Internet Explorer has encountered a problem and needs to close. we are sorry for inconvenience caused) and same way new browser also not opening. If you have any idea please let me know.

2 Answers   ME,


I have a library function , with that function 100 scripts are being called. The library function is changed(something is added) . how do i update all the scripts.

1 Answers   IBM,


Categories