how do you do database testing in qtp
- 5 Answers
- 19622 Views
- NIIT, I also Faced
- E-Mail Answers
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 |
Is it possible to check the Run time value property of a field through a Database Checkpoint ? Further, is it possible to localize and mention a particular cell , in the database dynamically. My requirement is that I would need to check the status of a particular field , that would change from an "Active" state to a "Stopped" state dynamically.
what is runmodes in QTP
In where you are keeping or maintaining shared object repository (file)in your appliction?
What is object repository?
For an application we automated QTP scripts. At the same time new requirement comes for a new module for the same application and its already developed. So how we automated now this new module with the old application(using old QTP script).
"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...
How to find given string is palindrome or not without using strreverse() function?
what is memory leakage?
16 Answers ITC Infotech, Panamax, TIT,
HoW to open QTP in Real time.after getting the qtp window how to log in .pl answer real time people
In a page i have N number of links at a time i would like to open those links by using QTP?how to do that?
How to capture the text from the application using QTP?
How to delete an object from the object repository?
WinRunner 
