What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 5811 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
How will you find the current time of the remote machine using QTP script?
How to run an integrated test scenario using Multiple Actions? How to use the QTP Step Generator?
How to execute a winrunner script in quicktest professional (qtp)?
please post the interview questions for QA position in FACTSET
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
If the objects hierarchy is changing from build to build, then how you will handle that condition?
Mention what are the different types of recording modes in qtp? Which will be used when?
Why we load add-ins in qtp?
Plz Explain How to access Or Store Script from VSS? Explain Real time work (qtp) where you store folders and next to how to you access that folders and how you maintain folders in VSS ? What are the Menu's in VSS? Suppose in Manual, by using Checkin Checkout u can access documents. how you access in QTp REal time?
How extensive or customized are the server logging and reporting requirements; are they considered an integral part of the system and do they require testing?
Is it possible to merge two object repository files in qtp?
Both static and dynamic arrays are handled by the vb script. Is it true?
How can you identify the browser and its information using the qtp script?
What are the steps involved in the recovery scenario wizard?
What is difference between shared and local object repository?
