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

How do u connect database through QTP
tell me both Ms Access and SQL

Answer Posted / prasanth

we can connect to database in QTP using "ADODB" connection
object.

Sample code for SQL Server:

set mycon = createobject("ADODB.Connection")

mycon.open("driver=SQLserver;server=localhost;database=
(database name);trusted_connection=yes")

set myresult=mycon.execute("select * from sample")

while myresult.EOF <> TRUE
msgbox.myresult.fields(0)
myresult.movenext
Wend


you can get the connection strings
for "connectionstrings.com"


Kumar.rnv@gmail.com
Broadridge

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the default add-ins in qtp?

997


Does QTP10 supports Windows 7OS +IE 9 combination? Which is the preffered combination ,Plz let me know?

3442


How to use checkpoints in qtp ?

1039


What do you mean by iteration?

1208


How many add-ins comes by default with quicktest professional?

957


How to handle dynamic objects in quicktest professional (qtp)?

946


Explain the features and benefits of quick test pro(qtp)?

975


can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

2118


What are the advantages of Object Repository?

1097


What is the quicktest professional testing process?

1156


In QTP TEST DIRECTOR COMBINATION WHAT IS THE PURPOSE OF TEST DIRECTOR? In Somebody says to store test cases and design test cases.?ok fine , but In test director 5.0 , QTp not launching. what u do?

1940


What are parameterizing tests?

1036


Difference between test object and run time object?

1010


How does you pass optional arguments in qtp?

1038


How many types of object repository in qtp?

1108