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

describe some problems that u had with automating testing tool?

0 Answers  


can a Function return more than one value..??? if so please give me the code for that.

5 Answers   DST Global Solutions,


Once the Actions are splitted , is there any way to merge them

3 Answers  


how can I read text in browser and export the same into text file?

5 Answers   HP,


What is checkpoints for quicktest professional?

0 Answers  






How should I click on the right click menu objects When I trying to add the object properties to the OR.It is showing only Window(Window).Not all the objects of the window. Also while recording I found No script. How to solve this>.

1 Answers  


How to check feasibility of the appliction?in automation testing?

0 Answers   CTS,


in Qtp,how to display user name and pwd (script)in data table(global sheet).

2 Answers  


For an application we automated QTP scripts. At the same time new requirement comes for a new module for the same application and its already developed. So how we automated now this new module with the old application(using old QTP script).

2 Answers   Bosch,


how to test background color and dynamic images during runtime

4 Answers   Accenture, Oracle,


what is the extension for QTP files?

11 Answers   AppLabs,


Among all the check points what is the most important checkpoint?

1 Answers  


Categories