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 |
What is keyword view and Expert view in QTP?
How to count the no of objects in XML file(QTP)
How to capture data from images in QTP and produce them in Excel sheet ?
If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?
Hybrid framework supports Descriptive programming. Is it true?
we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?
hello, i was install Q.T.P.8.2 in windows xp version .when i am running my programs all the desktop icons are disappear why so. please guide me anybody how can i come out side this problem.
Explain the Load testing process?
suppose by navigation i went from 1st page to 5th page write a script for coming from any page to the 1st page abd by executing where the page may be . it will come to 1st page give the code using gmail. give me mail id so that i can under this answer with out any doubt
When testing a web application, the url for each page changes, so using QTP how do u handle this scenario. If anyone knows please answer in detail about the whole procedure. Thanks a lot.
How comfortable are you in VB scripting?
What will be the output of the statements below? On error Resume Next Sum 100/0 if Sum= 0 Then msgbox "Pass" else msgbox "Fail" End If