Interested to Buy Any Domain ? << Click Here >> for more details...
What are the details steps to connect a remote mysql
database in QTP
- 1 Answers
- 6260 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
What is checkpoints for qtp?
Hi All, I have QTP installed on my machine but the application under test (AUT) is on remote desktop.My scenarios is like that,it should contain following steps. 1)Automatically it should click on start and then on remote desktop connection. 2)it should enter the IP address and then connect to remote desktop. 3)and then it should be able to record the application in remote machine and then run it also. Can somebody tell me how to record the application which is in remote machine.
Explain the parameter in qtp?
What is fragmentation and paging?
How may types of defects identify application or your currently working application?pls give me answer..
How to find the name of the machine where you are running your automation scripts in qtp?
How to create a standard checkpoint ?
How to find the length of the string in qtp?
How qtp identifies objects?
what is output value in QTP and how it can be used in automation testing
What is the difference between run time object and test object?
How you create new action in qtp?
How to do call a output parameter from one action to another action??/
How do you create new test sets in td?
There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code
