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 connect to data base?
 Question Submitted By :: Arpillai
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to connect to data base?
Answer
# 1
QTP supports interaction with Database using ADODB.

Set con = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")

'Create DSN(DataSourceName) for your database and specify 
the DSN here
'You can also establish connection using Provider name

con.open "DSN=MyDsn;UID=ravi;PWD=sample123"

con.execute "Insert into emp values(2500, 'Ravi')"

'Retrieve data from database
rs.open "select * from emp", con
while not rs.eof
  msgbox "ID = " & rs(0) & " Name = " & rs(1)
  rs.movenext
wend
 
Is This Answer Correct ?    1 Yes 0 No
Ravi
 
  Re: How to connect to data base?
Answer
# 2
You can write OLEDB script:

Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open
 
Is This Answer Correct ?    0 Yes 1 No
M.s.patil
 
 
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
What scripting language QTP of?  4
Among all the check points what is the most important checkpoint?  1
what version of test director supports the QTP? does testdirector supports the QTP9.0?  1
What are the challenges do we face while testing webbased applcations using the automation tool QTP or any?  1
is it possible to map an image as standard Object or u've to treat as virtual? how to map an Dynamic image into standard object?  1
How do we create and run the scripts with out using O.R. ?  4
Hi, this is venkatesh. Q: I have 10 files in a folder(say D:\). Out of which there are some .txt, .xls, .doc. I want to know how to get the count of each file using qtp? If U have any ans, plz write script for that... EDS3
What are the Automation Limitations??  1
I want to test advanced Java applications what kind of add- ins I have to install?  1
we have 10 actions in out test how can we convert 9th action is main action ? how ?  5
How to retrive data from a data table which is in 3rd row,4th column and place it in main script..like retrive name,date from data table..write script for this. Thatavarti-Technologies11
can u Give Procedure to Handle Pop Window & write Code for that CTS1
wht is the difference betn check point and output value? BirlaSoft4
What is TD plugin? For what purpose they are used . Ineed to connect QC9.2 with QTP 9.2 . Need to run some scripts IN QTP having the QC connectivity. Pls explain in detailed step Thanks in advnece HCL1
Explain script generated at the time of setting runtime property?  1
the presentation layer of my application is built using VB 6.0 and a series of C++ dlls and components. We do not use Java, VB.Net, C## or any other component that can be decompiled. We are automating the application using HP Quick Test Professional. It is not reconginizing the combo boxes, tabs etc.... Could you please suggest, whether QTP supports C++ dlls and components or not...if yes, could you please guide me, how to overcome this situation. Can we install any special add-ins for this C++? .When we are performing the recording/execution, the application becomes very slow. Your quick response will be highly solicited in this regard. Wipro1
how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes STC3
hi This is Harish.1. What is object repositery .2. what is frame works in QTP,what is keyword driven frame work,explain it and how to associate the folders.3.the build is developed in java, can we write scripting in vb .4.what is discriptive progaram,how to write it.5.what is process of QTp testing.6. how to associate the shared repository. 7.what is implicit and explicit 8.what is runtime data please replay me regards Harish Syntel3
can we use QTP for load testing instead of load runner?  3
How to make an Action as reusable?  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