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

how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

4122


Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

3190


How to make qtp understand the difference amongst the same type of objects .suppose there are 5 check boxes in a page and I have to choose the 2nd one, how to do that through script?

765


What is Distributed testing? How does UFT support it?

821


Explain the terms test and business component?

772


Explain the difference between data driven testing and parameterization ?

798


Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln

1649


How many ways we can parameterize data in quicktest professional (qtp)?

821


How can get count of list box?

869


What are the key elements available in test result window?

895


What are the various types of Actions in UFT?

809


how do u manipulating INI, DLL and / or registry files in support of your test environment? actually what do u mean by INI and DLL or registry files. plzzz its urgent do answer

1692


How to remove the associated function library?

762


what are the limitations of smart identification in qtp 9.0

2136


Explain building blocks of the bpt framework ?

789