ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
How to retrieve the data from database?
 Question Submitted By :: Rajaputra Arunsingh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to retrieve the data from database?
Answer
# 1
by using data base checkpoint what ever you want to 
retrieve the data
 
Is This Answer Correct ?    1 Yes 0 No
Haribabu
 
  Re: How to retrieve the data from database?
Answer
# 2
Hi Hari,

We can Retrieve data from database using datatable or Data 
bse checkpoint
 
Is This Answer Correct ?    0 Yes 0 No
Kranthi
 
 
 
  Re: How to retrieve the data from database?
Answer
# 3
Dim Dsn_conn,rs

Set objConnection=Createobject("ADODB.Connection")
Dsn_conn= "DSN=QT_Flight32;DBQ=C:\Program Files\Mercury 
Interactive\QuickTest 
Professional\samples\flight\app\flight32.mdb;Driver=C:\WINNT
\system32\odbcjt32.dll;DriverId=281;FIL=MS 
Access;MaxBufferSize=2048;PageTimeout=5;"
objConnection.Open(Dsn_conn)
Set rs=CreateObject("ADODB.RecordSet")

Set rs=objconnection.execute(" select  flight_Number from 
Flights where flight_Number>20330")

rs.MoveFirst

While Not rs.EOF
	Msgbox rs.fields.item("flight_Number")
	rs.movenext
Wend


.................Any more question mail me 
testingwithshyam@gmail.com
 
Is This Answer Correct ?    0 Yes 0 No
Shyam.meghansh
[Hydus Technologies (INIDA) Pvt Ltd]
 
  Re: How to retrieve the data from database?
Answer
# 4
dim con,cmd
set con=createobject("adodb.connection")
set com=createobject("adodb.command")
con.open"provider=sqloledb.1 or ora 
oledb.1;server=servername;uid=uid;pwd=password;database=data
sourcename"
cmd.activeconnection
cmd.execute"select*from tablename"
 
Is This Answer Correct ?    0 Yes 0 No
Asn
 
  Re: How to retrieve the data from database?
Answer
# 5
place ur course in data table.
right click on  it.select option import data from data base
 
Is This Answer Correct ?    0 Yes 0 No
Narendra Babu
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
hi friends i was tried to connect qtp with oracle database using provider.i got a error.so anyone can help me out by correct script  2
Can anyone explain about Keyword driven framework in detail and how to use it in case of any project  4
What are the difference between QTP and Winrunner  5
How to Parameterize Object repository in QTP?  4
In web page there is five OK buttons available, while recording i click on 3rd OK button, How QTP identify the 3rd OK button while running script? Is qtp identify 3rd ok button? Polaris5
DIFFERENCE BETWEEN WR 8.2 & QTP 8.2? HOW TO INTEGRATE WITH SOME OTHER TOOLS? CTS1
how can i do QTP Certification can any 1 tell me . How 1 approch and who to approch Hydus6
Whether it is possible to test the adobe's controls like zoom, resize, save etc using QTP...If yes, how u can do the same?  1
What is API  1
Whenever we use GETROPROPERTY function. NIIT6
what type automation is fofollowed in the project? Satyam1
how i will connect oracle or microsoft acess database through manually written Script Aurigo2
How to add check point?  2
How to open an application through scripting?  9
Can you tell me the differences between writing the VB script manually for a application and recording the same application in QTP , with a example?  1
What is log file? what is the use of Log fine. How to create? what are the contents and the main advantages of log files. plz do help me in this concepts as i have an interivew on qtp in a couple of days. plz do help me.. thanks in Advance.  1
1. IS A VIRTUAL OBJECT USED WHEN THE LABEL IS NOT RECOGNIZED BY QTP Ordain-Solutions6
what is the difference between Table checkpoint and Database checkpoint in QTP Ordain-Solutions2
in flight reservation ex once u login, u go into next window where we hav an option of new, open and help etc.. how to fetch those options and to go to respectiv tab accordingly using qtp.. plz let me knw answer for tis as early as possible. Thanks in advance... asha  1
How to Parameterize Object repository in QTP?  1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com