What are the details steps to connect a remote mysql
database in QTP



What are the details steps to connect a remote mysql database in QTP..

Answer / santhosh ankam

This is code to run sql query through qtp.

SQL "SELECT * FROM ORDERS"
connection_string "QT_Flight32"
columns 1
set connection CreateObject("ADODB.Connection")
connection.Open connection_string
set rs1 connection.Execute( SQL )
rows db_get_rows_count(rs1)
msgbox rows
rows rows-1
myval db_get_field_value(rs1 rows columns )
msgbox myval

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More QTP Interview Questions

what is runmodes in QTP

1 Answers  


Explain different type of event trigger option.

0 Answers  


How will you check that your test cases covered all the requirements?

0 Answers  


What is output value? How many types of output values are there in qtp?

0 Answers  


what is the difference between DATA TABLE and DATA SET?

2 Answers   Accenture,






In an application you have a web table. You are provided with an external Excel sheet with the same structure as that of the web table. How will you retrieve all data from the web table and compare it with corresponding data available in the excel sheet, using QTP? How will you report the results in QTP?

1 Answers  


get the order no from the following orderdetails orderstring="ORD13456PNR" eg:13456

10 Answers   Oracle,


How to make arguments optional in a function?

6 Answers   Liquid Crystal,


What are the differences between QTP 9.2 and 10? please explain e indetail......

2 Answers   Wipro,


Hi,Sudhanandareddy plz forword framework and ppts for QTP to me. This is my mail id: ranjith_99reddy@yahoo.co.in (your contact number also)

0 Answers  


any body plz send health care domain project to me with explanation any two modules on that project. mail_id: ranjith_99reddy@yahoo.co.in

0 Answers  


how to reverse a string with out using string or predefined function,ex:string is " i love india". the output should be like this "i evol aidni"

10 Answers   Aspire, MNC, Omega,


Categories