how we connect oracle or sql data server database to qtp.
- 4 Answers
- 29211 Views
- TCS, I also Faced
- E-Mail Answers
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
Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.
How many add-ins comes by default with quicktest professional?
Explain calling sub procedure.
Is it possible to switch between recording modes during a test creation?
what is the difference btn risks & Therads in the Test plan documentation?
How many number of actions possible in qtp?
How to test login module with different username and password by using data driven testing in QTP?
What is Associate Repository in QTP 9.2 ?
How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one
Why to use descriptive programming?
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?
How to interact tool & application build in QTP?
how will load the object during runtime?
What are the different kinds of test steps?
Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?
