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

how to test background color and dynamic images during runtime

4 Answers   CTS,


Does Low-level recording capture mouse movements?

0 Answers  


What is synchronization point in QTP?

0 Answers  


In qtp, explain what is crypt object

0 Answers  


what are build and version plz explain why nomber changes in build and version?

3 Answers  


what is Supplemental Objects ?

0 Answers  


What is the BPT(bussiness process testing ).and what is the main difference between BPT and QTP

3 Answers   EDS, GL Noble Denton, IIST,


Can I import a excel sheet in Action1 datatable? How?

2 Answers   IBM,


i have to login into gmail loginpage i have to pass testcase into userid and password by using functions. the test case of user id is it should take only lowerletters alphabetin between 4 to 6 length.it should not take spectial letters.it should not take numbers.testcase for password is it should take numbers and it should not take alphabets note the following things must happen 1 when i give correct password and userid that password and userid should be seen in QTP result and notepad,xl sheet 2 when i gave in valid password the system willgive message please give valid password that particular messaage should be seen in QTP result,norepa and xl sheet

0 Answers   IBM,


Hi guys pls any one send me the Qtp Licensed key of version 10.0 pls

0 Answers  


Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link

0 Answers  


what is object repository?

4 Answers  


Categories