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
How to save your test using quicktest professional (qtp)?
What is synchronization? What are the ways you can synchronize?
What is file database?
what is meant by function library?Public and private functions in function library? if private functions are applicable for only for the particular test means then y we have to add those to function library?
What are the views available in qtp?
Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in
Consider one application is open, clicking one menu will open another application in another browser. QTP does not catch the URL of the second browser(second application). can we capture it ?
How do you synchronization point through DP?
In an interview, what r the general questions asked in QTP? pls give me anwser to this question?
what is run-time data?
action contains public and private functions but do we resuable that action or not..If it is reusable How..plz tell me the ans
what are the critical test cases in crm? tell me atleast 5 critical test cases? what are the critical bug u find out while testing crm domain?
Explain quicktest professional testing process?
Explain more about the Test Fusion Report of QTP?
could any help me please, how to work on visual foxpro application using UFT