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



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

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

More QTP Interview Questions

How do you handle XML exceptions in QTP (Here it is Exception, not the checkpoint)

2 Answers   CFC, CTS,


What is keyword driven framework, what is "key" in It.

2 Answers   IBM,


How to handle Dynamically changing Objects in QTP?

4 Answers  


does test plan is in test strategy or test strategy is in test plan

2 Answers   Tanla Solutions,


what is the difference between window command and dialog command

1 Answers  


How can we add regular expression for date field (dd/mon/yyyy)?

3 Answers   CTS,


In our application (Web based application)we will get a pdf file and we have check a particular text in that pdf. Can any one tell how to check text in a pdf file. In the same pdf file it generating some links and I have to click that links. QTP unable recognizing that links, even id did record and playback qtp does not generating any script. Can any one help me….?

6 Answers  


what testing activities u may want to automate?

2 Answers  


what is run-time object in qtp? explain with example?

2 Answers  


Any limitation to XML Checkpoints?

1 Answers  


Write Descriptiv prg 4 login logn....txt bx password---txt bx ok---btn

2 Answers   Hewitt,


How to capture text from image to word

2 Answers  


Categories