how we connect oracle or sql data server database to qtp.
Answer Posted / ram
open qtp-->click record
In Insert Menu-->OutputValue-->Database Output value--
>select specify query manually radio button-->and click at
create button->click new-->select sqlserver from the popup
and click next-->next
u will get connection
DSN=database;UID=username;Trusted_Connection=Yes;APP=QuickTe
st Professional;WSID=computername;
and write sqlstatement
select columnid from tablename (dont put * instead of
columnid)
then automatically the below line is added in qtp
DbTable("DbTable").Output CheckPoint("DbTable")
and do remaining stuff.
u need some more clarification please send the mail to
i.krishna@rediffmail.com
Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
what is the difference betn QTP 8.0 AND PREVIOUS VERSION
what is the difference between data driver & data driven and driver script?
How will you check a web application for broken links using qtp?
X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?
Output values? i want a practical example
What is the script for database check point, bitmapchek point, regular expression ?
one screen page,that contains file , browse , update and cancel buttons.when we browse a file it should get update otherwise it should go to previous page.write negative test case for that.
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
Explain types of descriptive programming?
How does you test a weblink which is changing dynamically?
Explain the views in the QTP GUI?
how to download mercury qtp9.2 ny internet ?
what are the limitations of smart identification in qtp 9.0
Explain the terms test and business component?
Hi All, I need code for how to execute qtp scripts from excell sheet