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

Can anybody post some real time scenario in qtp? please its very urgent.

0 Answers   Kanbay,


Tell me the difference between QTP9.2, QTP9.5 and QTP10.0

1 Answers   Genpact, HSBC,


How can I map test requirement to Test Set (multiple test cases)? Under test lab, I have multiple test cases. I would like to map 1 requirement to all test cases under that test set (in test lab)? Currently, I think QC only allow mapping 1 test requirement to 1 test case. Instead I would like to map 1 test requirement to multiple test cases under one test lab.

4 Answers   CarrizalSoft Technologies, DST Global Solutions,


wt is the difference between global and action excel database in qtp?for example one action is calling another action the second action is using action excell sheet?if it is using global sheet what makes the difference?

2 Answers   Datamatics,


what is verification & validation?

2 Answers   Accenture,


how can we preform retesting(DATA driven test) using function please gine the code for loginpage

0 Answers   W3 Solutions,


What is the difference between "Call to copy of action", "Call to existing action" & "Call to winrunner action"?

5 Answers  


How is UFT 11.5 version different from UFT 12.0?

0 Answers  


I have an application running in Linux server. I am reaching the application through emulators like telnet. My operating system at the client side is Windows XP. Using emulator I am connecting the Linux server and working on the application. Can I automate the testing of the software running in Linux server using QTP. In short, does QTP support the applications running in Linux servers.

1 Answers  


Explain how you can find length of array in qtp?

0 Answers  


How to add a page checkpoint to your test?

1 Answers  


what is option explicit? what is the use of it?

9 Answers   Syntel,


Categories