how to connect qtp to sqlserver?(if any body know about this please send mail to me:sheik_feroz5@yahoo.com)thank u

Answer Posted / rajib

set conn=Createobject("ADODB.Connection")
Srvname="Driver=<>,Server=<>,UID=<>,Password=<>"
conn.open Srvname
Set Rec = CreateObject("ADODB.Recordset")
SQL="<SQL statement>"
Rec.open SQL ,conn

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to switch between recording modes during a test creation?

681


What are the factors on which script execution time is dependent?

702


how will load the object during runtime?

1672


how to find that a file has been completely downloaded or not? I told that "download Complete" pop up. but he told the tool doesn't recognize the pop up

3922


in a web page How to check and display a particular word from a paragraph?

2146






what is meant by source control?

1795


"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...

1551


whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

1688


what could go wrong with test automation?

1597


how to acess a test in RSA?

1768


• What type of testing questions will be asked for 2+ yrs exp people in interview?

1355


how do we know whether all objects are stored in the object repository or not? how can we know if a particular object is not stored in the repository?

1410


In what occasion we can specify global sheet and action sheet?

649


how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

1528


How can i initiate the objects to find uniquely in OR

1552