how to make connection to a remote mysql database in qtp
any one can please provid eme deatail steps.

Answer Posted / kishore

Set con = createobject("ADODB.connection")
Set rs = createobject"ADODB.Recordset")
Set com = createobject("ADODB.command")
con.open( "Driver=SQL SERVER;Server=server name (Where
DB is located);Database=DB name;Uid=uname;Pwd=pwd;" )
vf_com.Activeconnection = vf_con

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use setroproperty?

564


If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?

1575


Explain quicktest professional testing process?

555


in qtp if we record a object and we record the object using virtual wizard then by which way the object is recognized that means recorded

1514


Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay

2655






assume i have few url link how will i dynamically call then using descriptive programming?

1590


What are the types of object repository in qtp?

558


Can U Explain about QTP tool from older version to latest version also its differences?

1508


can any one please tell me which is the best institute in Bangalore to learn QA (crash course)? Thanks

1521


Your roles and responsibilities and daily tasks? (As automation tester)

2574


How to remove the associated function library?

524


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

1630


how to idetfy which test cases are automated?who will deside that plz tell me

1529


how can i sent QTP results to the Html, notefile ,xl file give me the code using g mail login page

1822


Why is Client side image is preferred over server side image?

1435