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

i have doubt suppose iam purly working in QTP, when i will work on sql and performence testing? pls any one clarify doubt?

0 Answers  


In Datatable having the data like this S.no Name Address 1 raj hyderabad 2 suresh Mumbai 3 shyam chennai 4 dev banglore i want to get the shyam row id & column id using scipting i.e 3,3

4 Answers   Broadridge,


please tellme ordernal identifiers in QTP?

2 Answers  


Explain the concept of object repository and how quicktest professional (qtp) recognises objects?

0 Answers  


1.How to record ,capture and also script to capture the close buttons. 2.How to record ,capture and also script to capture the options ---File ->save and File ->close in a browser and PDF files. 3.How to compare the Excel sheet values in a report using QTP scripting. 4.How to compare 2 PDf reports using QTP scripts as well reording. 5.How to compare 2 Excel reports using QTP scripts as well reording. 6.How to save a PDF report to a folder and then translate the report to an Excel type of report and compare that Excel Report with an other excel report. Please clarify me

0 Answers  


Hi This is tanya actually im facing problem in Qtp actully some time QTP doesnot recoznise the recorded object due to which script is going to fail.so can you tell me how we can handle this situation and i have another concerened issue is that at the time of run New errors comes every time so how we can handle this sitauation how we can add Recovery scenarios to the script.some time application runs successfully and some time it produces new error thats why i am facing lot of problem please give me the sugeestion as soon as possible.

2 Answers  


What is difference between version 6.5 and 8.2 in QTP?

0 Answers  


Explain more about the Test Fusion Report of QTP?

0 Answers  


What kind of performance is expected on the client side (e.g., how fast should pages appear, how fast should animations, applets, etc. load and run)?

0 Answers  


How to send QTP scripts to our colleagues?

1 Answers   Virtusa,


Which is the best QTP training institute in Delhi/NCR region and what is the approximate fee for QTP course (Basics and Advanced)

0 Answers  


i am new to qtp i do not know how to write script how to write the code to login if it fails how to able error messages

4 Answers   Accenture,


Categories