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

How to test a web application using QTP?there is no any .exe file in web app,then how we can take the application for testing

2 Answers  


How you debug your script?

0 Answers  


Is it possible to check the Run time value property of a field through a Database Checkpoint ? Further, is it possible to localize and mention a particular cell , in the database dynamically. My requirement is that I would need to check the status of a particular field , that would change from an "Active" state to a "Stopped" state dynamically.

1 Answers   CTS,


How i can change shared repository to per test repository in qtp

1 Answers  


how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes

4 Answers   STC,


in a web page hoe to check the dynamic links that rechabging with out using regular expressions

0 Answers   CTS,


what are the different Frame Works in Quick Test Proffessional testing

3 Answers   Wipro,


Tell me the QTP Advantages and Disadvatages ?

6 Answers   Accenture, CTS, GE,


did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions

3 Answers  


Hi All, I am 4 yrs experieced in manual testing and new to automation tool QTP. Iam trying to learn it thru online and material i have.I am able to understand but unable to trace out which method or function to be used where necessary in VB Script. How come we know the functions or methods to be used to open a window when clicking on button or so...Pls suggest me.How can i proceed further to apt VB Script.

0 Answers  


What is Object Spy in QTP?

1 Answers   Crea,


Hi, It is HR question. What are the qualities you like and dislike in your Project Manager?

2 Answers   TCS,


Categories