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 to retrieve the object properties at runtime without the usage of GetROProperty?

3 Answers   Cap Gemini,


What is the use of Debug Viewer?

0 Answers  


What is the ur roles and responsibilities as automation testing engineer?

2 Answers   Atos Origin,


What are the advantages of Automation objects than Test Objects?

2 Answers   Adobe,


what are the areas that cannot be tested using an automated tool? list a few

7 Answers  






Suppose there is a link present somewhere in an excel sheet. Find the link and click on it. How to write a script using Excel application object in QTP?

1 Answers  


hi guys, pls tell me for testing institution training hub, hitech city is best or not?

0 Answers  


Hi, How Accessibility checkpoint in QTP can be implemented in the test script?

0 Answers  


how to convert 100 into hundred repees only and viceversa

0 Answers  


Synchronization methods?

8 Answers   Ordain Solutions,


How to retrieve the property of an object in QTP?

5 Answers  


Which advantages helping QTP to hold the position of "Market Leader" for such a long period?

0 Answers  


Categories