How can you connect the database with QTP?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how interviews will be on QTP?

1730


why you have standardized functions? plzzz guys with real time exp. do answer

1653


How do you configure QTP AND Test director?

1719


What is keyword view in qtp?

741


To which environments does quicktest professional supports?

769


What is difference in global and action sheet in qtp?

852


Have you used xml check point in your project?

774


What are the Test design techniques you uses in ur project?

1729


i need qtp tutorial. pls send it to sridhar.k151@g mail.com

1885


How many types of recording modes in qtp? Which will be used when?

773


I have developed and executed a script successfully, and saved the same to QC. When I tried to execute the script from QC, the script is not executing. What are the possible reasons?”

809


In order to select an automation tool for automating ur application, what r the things u need to consider? For eg i will go for automation; 1) When there is a lot of retesting and regression testing. 2) Return on investments. 3) Whether the tool supports the appln. 4)--------------, etc. Pls give me more number of points because my answer did not satisfy the interviewer. Very urgent pls

1683


What is quicktest professional window?

777


Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

1679


How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.

753