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...

write progamming connecting QTP to database sql? this is
question asked by interview? please give sql, pl/sql related
answer?pls any answer this?

Answer Posted / rangarao

Set myconn=CreateObject("ADODB.Connectionn")
myconn.Open
("Provider=OraOLEDB.Oracle;DataSource=Your_Oracle_Database;o
SAuthent=1;")
if(myconn.state=1) Then
Set rec=myconn.Execute("query")
while rec.EOF<>TRUE
msgbox rec.fields(colname)(We can also Specify column index)
rec.MoveNext
wend
End if
rec.Close
myconn.Close

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between Recording time object identification and Run time (Execution) time.

1653


Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri

1896


Describe synchronization point.

1159


breef description of batch testing ?

2136


How can we use the "CreateObject("Shell.Application")" in QTP and what is the definition and purpose of it?

3579


In keyward driven framework what will be the step for yahoo login page ,inbox logout,plz explain in detail

2079


What are the advantages of a Hybrid framework?

1152


Hi,All How to create a link in excel sheet using qtp

3451


When Recovery scenario actually starts while testing the application?

2040


Do you know how to connect database? Can you tell me the procedures?

1002


How does qtp identify objects in the application?

1139


1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?

2118


X flies from Hyd to bangalore using different methods of transportation. write the test scenarios and test cases for this?

2053


supose i hv to acsess some functionlaties of a test in 1 machin , some part other machin how can acsess?

1822


Differentiate the type of test cases which can be automated and which cannot be automated?

1043