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 can we perform web datatable operations on webpages(Like rowcount,col count,cell data)?

2 Answers   Syntel,


what is the syntax for regular expression in QTP? how to create user defined functions in QTP?

6 Answers   CTS, MBT, TCS,


please post the interview questions for QA position in FACTSET

0 Answers   FactSet Systems,


How to capture data from images in QTP and produce them in Excel sheet ? please ans...

3 Answers   Sapient,


What is the extension of script and object repository files in QTP?

9 Answers  






Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak

0 Answers  


hello, i was install Q.T.P.8.2 in windows xp version .when i am running my programs all the desktop icons are disappear why so. please guide me anybody how can i come out side this problem.

3 Answers  


1>why parameterization is necessary in qtp? 2>if we give constant value then what problem?

5 Answers   Wipro,


What is creation time property and how does it work?

1 Answers  


I want to know what are QTP functons and what are VB script functions. What is the difference between them.When we have to use these functions.

0 Answers  


What are the common defects found in your project? (in qtp interview)

0 Answers   TCS,


how to open Excel sheet & write in it & save it?

1 Answers   InTech,


Categories