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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / alok

Through Data Driver Wizard

Is This Answer Correct ?    2 Yes 6 No

Post New Answer

More QTP Interview Questions

How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What is the difference between them? How to handle script issues?

0 Answers  


why we use environment variables

5 Answers  


Can anyone pls tell me how to do action parameterization (input and output parameters) with respect to login window and insert order of flight reservation window in detail( pls give a clear step by step explanation with example) anyone please. Will be very thankful to u

0 Answers   Avenger Software,


i don't have any experience in qtp? Can u please tell me What work i have to do?

4 Answers  


Please Clarify if smartidentfication is used at runtime when qtp does not recogonize the objects

3 Answers   Ordain Solutions,


Explain the types of object repositorys in qtp?

0 Answers  


Hi,can anyone tell me How to found the number of 1's and 2's in the given format 1,1,2,2,3,3,4,2 using vbscript Thanks in advance

3 Answers  


How can we do this one ? at runtime qtpwindow and browser aren't disply on monitor (or) aren't visible on desktop?how?

1 Answers  


Hi, My application is a web application which was developed by Java. In that application we have applets to do some operations. Is it possible to recognize applets using QTP? If yes, how? pls, help me this

1 Answers  


can anyone tell me from where i can download qtp demo or crack version

0 Answers  


Please explain about unicode compatibility in QTP. how we can able to use it. Please help me

1 Answers  


how to test background color and dynamic images during runtime

4 Answers   Accenture, Oracle,


Categories