Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How do you invoke an application using the step generator in qtp?

5 Answers  


To which environments does quicktest professional (qtp) supports?

0 Answers  


Can any body please tell me the steps of keyword driven framework of QTP.

0 Answers   TCS,


How to open a new test using quicktest professional (qtp)?

0 Answers  


How can i Save the snapshots in a specified folders using Scripting in QTP?

1 Answers  


I am a beginner plz tell me,how do we write scripts in QTP? In my opinion we can write scipts in expert view or there is another option where we can write scripts. plz tell me.

5 Answers  


How to "Turn Off" QTP results after running a Script?

3 Answers   Crea,


one ok button and one text box is there.when i click on ok button in that text box one no. will display from 1 to 100 randomley.if that is not 100 when we click on ok button again ,again another text box ll created with another no. we will continue this till the text box created and displays 100.and when its 100 ok button should disabled. remember thet no will display not seriely ,it displays randomley,and each time new text box will created.

6 Answers   ADP,


what is smart identification?

7 Answers  


Hi Frenz... I would like to take up the QTP certification . Can anyone tell me what is the procedure. n if anybody have the study materials pls fwd it to jkpunathil@gmail.com

0 Answers  


what is the abbrivation of .mtr in action reposirtory?

8 Answers   GE,


When you are running a batch test of 5 scripts and in 2nd script appln crashed, what hpns then?

4 Answers   BirlaSoft,


Categories