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       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
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 we connect oracle or sql data server database to qtp.
Hi Ram I was your answer for this. Can you kindly let me
know in details steps on How we can connect to database. i
am using  QTP9.2 and SQL Server Database. I am new for QTP
and this would be of great help.Thanks
 Question Submitted By :: Deepu
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how we connect oracle or sql data server database to qtp. Hi Ram I was your answer for this. Can you kindly let me know in details steps on How we can connect to database. i am using QTP9.2 and SQL Server Database. I am new for QTP and this would be of great help.Thanks
Answer
# 1		 
http://funandknowledge.blogspot.com/2008/03/qt.html
 
Is This Answer Correct ?    0 Yes 0 No
Snig
 
  Re: how we connect oracle or sql data server database to qtp. Hi Ram I was your answer for this. Can you kindly let me know in details steps on How we can connect to database. i am using QTP9.2 and SQL Server Database. I am new for QTP and this would be of great help.Thanks
Answer
# 2		 
'Declaration for SQL
Dim objConnection,objRecordset,count1

'Connecting to the database
Set objConnection = CreateObject("ADODB.Connection")

objConnection.Open "Driver={SQL Server};" & "Server=YOUR 
SQL SERVER NAME;" & "Database= DB NAME;" & "UID=USERID;" 
& "PWD=DB PASSWORD;"

'Running the query
sql1 = "GIVE UR QUERY HERE"
'Create record set for the query
Set objRecordset = CreateObject("ADODB.Recordset")
objRecordset.Open sql1, objConnection

As this is a Back-End process, you cannot view the result 
set. so you can place the result in the datatable using the 
following steps:


'Retrieving data from the database to the data table
count1 =1
While Not objRecordset.EOF
datatable.SetcurrentRow (count1)
          Datatable("C",1)= objRecordset("nbr").value
objRecordset.movenext
count1 = count1+1
wend
 
Is This Answer Correct ?    0 Yes 2 No
Gms
 
 
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
what do u mean by test harnesses in qtp? Verizon1
Hi,The question is write a script for the following scenario. scenario:in a job portal i entered QTP 3yrs testing then click search button.then it displays results like Test lead bangalore (here is a checkbox). Test lead hyderabad check box so on... question is if test lead position in bangalore then checkbox shld be enabled automatically.. Thatavarti-Technologies3
How do you change Logical Name of the object in test script? TCS1
I have two actions in my QTP test and two iterations in my DataSheet. I want to execute the Action 1 for the two iterations only after which i want to exceute the next Action2. How is this possible?  2
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
what is risks of testing a project? AppLabs4
What is SQL injection? CTS2
can we install qtp in windows vista  1
how to create the varibles and how these are connect to qtp? plz tell me  2
when i perametarization of the test through outputcheckpoint,i have seen run time error i.e outputcheckpoint mismatch .Plz tell anybody to me(qtp).How to clear that?  1
the build is develeped in Java. is possible to write scripting in vb using QTP ?  3
I need diffrences between Object Identification, Smart Identification, Regular expresion,Low-Level Recording (enables you to record on any object in your application, whether or not QuickTest recognizes the specific object or the specific operation.) I am working on Web Application. In that object caption will change dynamically. For example, consider “Save” button. On clicking save button the caption changing as “ EDIT ”. From above concept which concept I have to use here? Ordain-Solutions2
What is the use of sendkeys.In which cases we Use this sendkey.Pls explain with example. Cap-Gemini2
hello, i was install Q.T.P.8.2 in windows xp version .when i am running my programs all the desktop icons are disappear why so. please guide me anybody how can i come out side this problem.  2
Tell when we call the function? tell with example.  1
How we will execute(run) the scripts in qtp 8.2?  1
How to export data present in Datatable to an ".xls" file?  1
What is QTP Frame Work ,and i want it in detail Value-Labs1
If some requirements r changed during the testing process ,then how can u handle this in frame work?  1
What is data driven testing in QTP? Agile-Software6
 
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