What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 5497 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
give me an example where u used good judgement and logic in solving a problem
How do you open adobe acrobat file in QTP and do some testing on that file ?
what is the difference between IE & Netscape in web testing on a log in page
How many ways we can parameterize data in quicktest professional (qtp)?
in my application,validation message has in japanise language.how to validate this message is appears properly or not
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
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
How many types of trigger events are there in qtp?
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
what r the main attributes of test automation?
Does QTP run in any environment?
assume i have few url link how will i dynamically call then using descriptive programming?
How to analyzing test results using quicktest professional (qtp)?
What are the different attribute used with regular expression?
If there is a change in the object type eg: A button is changed as link, 1. How to edit that in the shared object repository. 2.What options are available to edit the object within shared object repository other than copy from loca; 3.What would be the effect of the change in Coded Scripts within QTP and Functions stored in .vbs file which are loaded and used in QTP
