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 |
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
How you debug your script?
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.
How i can change shared repository to per test repository in qtp
how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes
in a web page hoe to check the dynamic links that rechabging with out using regular expressions
what are the different Frame Works in Quick Test Proffessional testing
Tell me the QTP Advantages and Disadvatages ?
did you perform retesting(DATA DRIVEN test) using functions with out using datatable methods how can you perform retesting using functions
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.
What is Object Spy in QTP?
Hi, It is HR question. What are the qualities you like and dislike in your Project Manager?