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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 oracle(sqlserver) database to QTP
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to connect to oracle(sqlserver) database to QTP
Answer
# 1
we can connect to oracle database throught conntection 
string....
code for connecting to db

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset");
con.ConnectionString="DRIVER={oracle in orahome92};SERVER=
(servername);UID=(username);PWD=(password);DBQ=dbserver"
con.open
query="select * from tablename"
rs.open query,con
while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
wend
rs.close
con.close
set rs=nothing
set con=nothing

any coments always welcome
 
Is This Answer Correct ?    4 Yes 0 No
Madhumitha
 
  Re: How to connect to oracle(sqlserver) database to QTP
Answer
# 2
by odbc connection using DSN
 
Is This Answer Correct ?    2 Yes 0 No
Raghavan
 
 
 
  Re: How to connect to oracle(sqlserver) database to QTP
Answer
# 3
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing
 
Is This Answer Correct ?    0 Yes 1 No
Adarsh (saama Technologies)
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
Which Databases supports for QTP? CTS2
can u please explain what r the challenges u faced in ur automation testing Genpact1
What is the current version of QTP and now it is the product of Mercury or HP TCS9
Did u use check points during ur work experience ? FedEx3
What is the difference between Image Checkpoint and Bitmap Checkpoint?  4
While testing .net applications with QTP 9.1 in normal recording mode, QTP records my unintentional mouse clicks and window dragging which I don't want. But I can't stop QTP recording those mouse clicks and window dragging. Can somebody let me know how I can get rid of it, please ! Thanks.  1
Explain about Hybrid Framework IBM2
can anyone please tell me what are all the shortcut keys used for qtp9.2? Thanks in advance..i expect ur valuable reply that help us our team???  1
How to map Test cases to the script? Please do anwser urgently?Thanks  3
WHAT IS PARAMITARIZATION?  8
What is XML checkpoint in QTP. How we can use in Web Based application LinkEdge2
If u don't have any Knowledge on perticular application but they give that application to u for Testing ? Then How we wil move towards testing on that application? HP16
What is User defined function in QTP Bank-Of-America4
What is the Maximum syncronization timeout in seconds in QTP 9.5 Polaris4
what is recovery scenario in QTP? what is the need of the recovery scenario in QTP? what are the advantages of the recovery scenarios in QTP? CTS3
Which object model is not supported by QTP? a)COM b)DECOM c)DOM d)DCOM. Pls explain about theese object models?  1
Give a comment on Regular Expressions using QTP?  4
What is the concept of hooking in QTP?  1
How many ways we can parameterize data in QTP ?  6
How to compare source and target database in testing? Can anybody please tell me in detail the procedure how to compare it?  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