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

What is the QTP test frame work?

3 Answers   IBM,


What is the difference between Call to Action and Copy Action?

2 Answers   Satyam,


What is the Risk Analysis? Waht types of risk analysis are there?

1 Answers  


How many types of trigger events are there in qtp?

0 Answers  


In QTP whether is it possible to call a function from one action to another action?

1 Answers  


What is post recovery scenario?

0 Answers  


How to capture dynamic values in load runner and how Each of the captured values are to be written to a text file (c:\temp\LoadRunner1.txt)

0 Answers   TCS,


how qtp identify two objects having same name, supose objects are in same page also with same name,specify spl feature.

5 Answers   IGT, Microsoft,


I am Using QTP 9.1 version. I have created a Shared Object Repository. The size of Shared Object REpository is 9 MB. In my system i am able to execute the script very flexibly and it is very fast. But if i copy the same code into other system with the same configuration, it is executing very slowly(i.e dam slow). It is not happening in all machines it is in only some machines. Can please any one give th esolution. It is high priority to me as i need to give demo to client on their machines.

4 Answers   TCS,


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  


With out using the task manager,how to close the application using vbscript and what is the statement?

1 Answers  


What are the types of Object Repositories in QTP?

1 Answers   Ordain Solutions,


Categories