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


Please Help Members By Posting Answers For Below Questions

what is the difference betn QTP 8.0 AND PREVIOUS VERSION

2186


what is the difference between data driver & data driven and driver script?

2422


How will you check a web application for broken links using qtp?

772


X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?

1771


Output values? i want a practical example

1515


What is the script for database check point, bitmapchek point, regular expression ?

1805


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.

1707


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?

4942


Explain types of descriptive programming?

810


How does you test a weblink which is changing dynamically?

780


Explain the views in the QTP GUI?

783


how to download mercury qtp9.2 ny internet ?

3206


what are the limitations of smart identification in qtp 9.0

2122


Explain the terms test and business component?

763


Hi All, I need code for how to execute qtp scripts from excell sheet

1665