How can you connect the database with QTP?

Answers were Sorted based on User's Feedback



How can you connect the database with QTP?..

Answer / sandeep.puchakayala

Thru Data Base Wizard in QTP

Is This Answer Correct ?    2 Yes 0 No

How can you connect the database with QTP?..

Answer / siva

set mycon = CreateObject("ADODB.Connection")
mycon.open("driver=SQL Server;Server=localhost;database=(database name);trusted_connection=yes")
set myresult=mycon.execute(Select * from emp)
while myresult.EOF<>TRUE
msgbox.myresult.fields(0)
myresult.movenext
wend

Is This Answer Correct ?    2 Yes 0 No

How can you connect the database with QTP?..

Answer / prashanth

Hi Sandeep,
What are the steps through database wizanrd, will u give
clear steps.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

How many add-ins comes by default with quicktest professional?

0 Answers  


In Test Director bug rEPORTS, wHAT ARE THE CONTENTS(fIELDS)? iF yoU PREAPARE BUG REPORT IN eXCEL sHEET , hOW U SEND TO dEVELOPMENT TEAM THRW T.D?

1 Answers  


What is output value in QTP? Why do we use the output value in QTP?How many types of output values are there in QTP? what are their respective usage in QTP?

14 Answers   IBM,


difference between multiple parameterization and data driven wizard in QTP?

1 Answers  


what are the different Frame Works in Quick Test Proffessional testing

3 Answers   Wipro,






Can any one tell me about "Mapping Repository Parameter Values" and why we use it....??How to use it???Please, tell the preconditions also...........???? Thanks in Advance

0 Answers  


How can you quit from Action.

2 Answers  


What are the two types of repositories available, explain them?

0 Answers  


how to count spaces in a given string ex: "this is jagadeesh" in QTP with simple functional script

5 Answers   Cap Gemini,


Does QTP support Java Script also. Which is one is preferrable for QTP, VB script or Java script

18 Answers   IBM,


Why QTP is termed as a Record and Playback tool?

1 Answers  


How to execute a WinRunner Script in QTP?

3 Answers   IBM,


Categories