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
I want to do QTP Certification what is the pattern of Question paper.
hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?
How to save your test using quicktest professional?
what is the diffrence bw qtp architectute and qtp framework?
Explain process of smart Identification in QTP?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
Explain how Does Run time data (Parameterization) is handled in QTP?
How do you perform Regreession Testing?
Hi I have exp in manual testing and planning to move in automation testing qtp(9.2).So can help me how to automate customer relationship management tool using qtp and vb script this tool already developed so how can I test it whatever maintaining by development team like documents,various options just give the whole life cycle thanks in advance
Explain the parameter in qtp?
Is QTP Supports SWT applications? If yes, can you write a sample script for opening a new package in eclipse.
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
What are the different types of functions available in qtp and explain ?
What is data driver in qtp?
what is output value in QTP and how it can be used in automation testing