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 will you set a unique four digit number in an edit field in QTP?

2 Answers   IBM,


QTP is not displaying in OBJECT SELECTION-CHECKPOINT PROPERTIES boxs only WINDOW AND WIN OBJECT remaining pages and links , images not displaying in web application testing. how can I get the pages and links in object selection? Please anyone tell me?

1 Answers  


How to data driven test for Win objects in QTP ?

0 Answers  


any body want to learn qtp with real time concept on Banking domain contact ciraaj@gmail.com

1 Answers  


hi, i am trying to capture "web element" names in a web page, and i written the code like this,, with Browser("title:=") with .page("") .webelement("htmltag:=...").getroproperty("innertext") end with end with //////////////////////////////////////////////////////////////////////////////////// QTP RETURN ERROR like this: " object's description matches more than one of the objects currently displayed in your application. Add additional properties to the object description in order to uniquely identify the object" ok fine , i need to search another property other than "index" i use all the properties like class,text,innerhtml,innertext,visible=true,x , y,abs x ,abs y...but qtp returns error ..... in this webpage index is difficult to find? how to solve

1 Answers   IBM,


what are the main differences between keyword driven frame work and data driven frame work?

1 Answers   UHG,


in a database table there are 3 columns (name , marks,grade) , in application after retrieving data from db to fields name, marks click ok button then grade should displayed ---for this how to write vb script prgm

3 Answers   IBM,


Can we create test script with out Step Generator?

4 Answers  


can we take 'dim my pen is good' as a paramerter

2 Answers  


if there r 10 windows open in QTP write a command to close all 10 windows at a time ?

11 Answers   Wipro,


Explain Different types of Checkpoints in Quick Test Professional?

2 Answers   Crea,


Can anybody help me by sharing the code for checkbox in qtp using vbscript.

2 Answers  


Categories