How can you connect the database with QTP?

Answers were Sorted based on User's Feedback



How can you connect the database with QTP?..

Answer / sandeep.puchakayala

Thru Data Base Wizard in QTP

Is This Answer Correct ?    2 Yes 0 No

How can you connect the database with QTP?..

Answer / siva

set mycon = CreateObject("ADODB.Connection")
mycon.open("driver=SQL Server;Server=localhost;database=(database name);trusted_connection=yes")
set myresult=mycon.execute(Select * from emp)
while myresult.EOF<>TRUE
msgbox.myresult.fields(0)
myresult.movenext
wend

Is This Answer Correct ?    2 Yes 0 No

How can you connect the database with QTP?..

Answer / prashanth

Hi Sandeep,
What are the steps through database wizanrd, will u give
clear steps.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More QTP Interview Questions

What are the main differences of qtp and win runner?

0 Answers  


How will you test a stapler?

0 Answers  


How to use the object spy in quicktest professional 8.0 version?

0 Answers  


could any help me please, how to work on visual foxpro application using UFT

0 Answers   NA,


I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, as i'm not in a possition to afford any 'Fee' to join in any institutions. Hence, if possible, kinldy mail PDF file to my mail-ID: chakri_avala@yahoo.co.in Regards, Chakradhar Yadav.

95 Answers   Cap Gemini, Citrix, CTS, IBM, Logistics, QA InfoTech,






Does QTP support flat files? If yes what are those?

2 Answers  


if there is two login button in your page, how you know that this login button is correct for login .

2 Answers  


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

1 Answers  


Hi Friends, Can you please answer these questions of QTP Certification? 1.) What are bitmap checkpoints sensitive to? A. Image size and object type B. Object type and image type C. Screen resolution and object type D. Screen resolution and image size 2.)What are the phases in the QuickTest workflow? A. Plan, Record, Enhance, Run B. Prepare, Record, Verify, Run C. Plan, Create, Verify & Enhance D. Prepare, Create, Verify & Enhance, Integrate 3.) What are the two most commonly used ADO objects? A. Fields B. Execute C. Connection, RecordSet D. Open, ConnectionString 4.)What options are available to filter objects in the Target Object Repository pane when merging object repositories? A. Show all objects or Show only objects with conflicting object types B. Show all objects or Show only objects with conflicting descriptions C. Show only objects with conflicting logical names or Show only objects with conflicting object types D. Show only objects with conflicting logical names or Show only objects with conflicting descriptions 5.)Which of the following is an example of a missing resource? A. An object B. Run Results C. A Regular Action D. An External Action 6.)What method is used to retrieve the number of columns in the query results? A. Fields.Count B. Fields.Item(EOF) C. Fields.Count(BOF) D. Fields.Count.Value 7.)In VB Script functions, which one is false among the following a. Variables must be declared before use b. Variables may not be declared before use c. Variables may be declared without data types None

2 Answers  


What is positive test case and Negative Test case? What is the meaning of Real World Scenario's?

2 Answers   TCS,


in login module login button chage regularly(means login button change to submit button).What is the code for it.

3 Answers  


Hi, I am trying to automate the web application for generating Reports.I am facing issue with IE while running the script. After 4 report IE crashes.I am using QTP 9.5 with IE version 7. Can anubody give me solution for this issue. Thanks in advance-Jyotsna

0 Answers  


Categories