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 i will connect oracle or microsoft acess database 
through manually written Script
 Question Submitted By :: Khem
I also faced this Question!!     Rank Answer Posted By  
 
  Re: how i will connect oracle or microsoft acess database through manually written Script
Answer
# 1
DIM ADDCON
DIM RECSET

SET ADDDCON = CREATEOBJECT("ADODB.CONNECTION")
ADDCON.OPEN "DSN= ;UID= ;PWD= ;"
SET RECSET = ADDCON.EXECUTE("SELECT.....)
WHILE RECSET.EOF
       .........
       .........
WEND
SET ADDCON = NOTHING
SET RECSET = NOTHING
 
Is This Answer Correct ?    0 Yes 1 No
Sashikanth
 
  Re: how i will connect oracle or microsoft acess database through manually written Script
Answer
# 2
'This is for Microsoft Access

dim con,rs

set con=createobject("adodb.connection")
set rs=createobject("adodb.recordset")

con.provider="microsoft.jet.oledb.4.0"

con.open "d:\testdata.mdb"
rs.open "select * from emp",con

do while not rs.eof
vbwindow("form1").vbedit("val1").set rs.fields("v1")
vbwindow("form1").vbedit("val2").set rs.fields("v2")
vbwindow("form1").vbbutton("validate").click

rs.movenext
Loop

' Oracle Connection

con.open
"provider=oraoledb.1;server=localhost;uid=scott;pwd=tiger;datbase=testdata"
 
Is This Answer Correct ?    0 Yes 2 No
Baba Fakruddin
 
 
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
What is SQL injection? CTS2
What is the main difference between QTP 8.0& QTP 9.2.And what r the features and benefits of QTP. HCL1
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
Hi Friends, I have an application that is having some options to choose. While doing business transaction I need to select one option among from available options. But here the thing is, we won't get one option which we've chosen already and the available options will get automatically from the system with time basis, moreover each and every option having with various label names respective to that option. So obviously if I run my recorded script will automatically gets fail, even though it got pass at first time. Could anyone please give me appropriate solution for this. I would be greatly obliged with you if you give the solution as soon as possible. Zensar1
what ar the challenges do we face while testing webbased applications using the automation tool qtp or any? TCS4
what properties do use to identify a browser and page while using descriptive programming? TCS3
In a webpage how to check the dynamic links that re changing regularly?( without using regular expressions.) Misys3
New to QTP: In a qtp flight booking application, I tried to parameterize the to and from drop down lists using data table, depending on ur drop down selection it will pop up a list of flights. Here I am not finding a way to select flight randomly from given list... Thanks in advance guys.  1
how to insert QTP to display errors and other description in the test results instead of halting execution by throwing error in the mid of executin due to an error (for object not found)? Ordain-Solutions1
This is Ajay i have few douts if anybody know pls give me reply. 1. i have opend 2 gmails i am working with 1 gmail i want to close other gmail by usig script. 2.i have 10 links in a page all of them have same properties& names i want to click on 5link by using script. 3.i have one combobox in that i want to see all the citynames in the combobox and i have to check weather hyderabad is present or not. 4. size of objectrepository. 5.what r problems we get during writing the script. 6.is it possible to compare to excel sheets in qtp if possible wht is the script. 7.example for lowlevelrecording Symantic-Space2
What is the difference betweent test and component?  1
What are "Ordinal Identifiers" and where it is used in QTP. AS FAR AS i KNOW, its is used to identify the object. but i want clarity regarding this.  1
Consider a scenario where there are two action sheets say action 1 and action 2. Can Action 1 take values from action 2 data sheet or vice versa. If so, how? Oracle6
in howmany ways you perfrom batchtesting Lehman-Brothers5
How can we change(increase or decrease)the size of a array variable with out loosing the previous values DST-Global-Solutions1
Once we get the Test Result from QTP.,I Have to convert into Excel file format..Is it possible..Can any gudie me regarding this... For Example : Total Test Case is : XXXXX Test Case passed : XXX Test Case Failed : XXX -------- Total XXXXXX ---------  6
How open an excel sheet in QTP(not a run time )? Tech-Mahindra1
how to write the descriptive programming in QTP for loginwindow.without using Step generator,object repository for referecnes STC3
It is very difficult to test in manual for that we go to DATA DRIVEN TEST.  3
Is it possible to return multiple values from a function..? Then how..?  2
 
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