Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how i will connect oracle or microsoft acess database
through manually written Script

Answers were Sorted based on User's Feedback



how i will connect oracle or microsoft acess database through manually written Script..

Answer / sashikanth

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

how i will connect oracle or microsoft acess database through manually written Script..

Answer / baba fakruddin

'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

Post New Answer

More QTP Interview Questions

What VBScript operators, functions, and statements do you use in QuickTest Professional?

0 Answers  


When QTP object wait time is 10 seconds, and in test script wait time is 5 seconds and in function library wait time is 2 seconds how much time does the wait occur? or which is given priority.

0 Answers  


how can we do the frame work in qtp

0 Answers   L&T,


I have a drop down box to show selected number of records in result page.It contains 4 items like 10, 25,50 and 100. when i was recordes script for seelcting each item and checking selecting number of records in the result page( it is in the same page in the table format)it is generating a new page with same controls( objects) in the OR. how to avaid these in OR? is it possible to write DP for only these lines?, remaining(remaingin lines of code) objects i want use from OR only. One more problemis if change ( add /remove properties of an OBJECT in OR , my ( recorded )application is not running.

5 Answers   Virtusa,


Why use Regular Expressions?

1 Answers  


How u perform exception handling in QTp,what is other name for ths

1 Answers   Lehman Brothers,


Java add-in is need to work on java oriented project ?

3 Answers  


What are the problems / difficulties faced when you used Smart Identification ?

2 Answers   Keane India Ltd,


What is the D/B Test managemet tool and bug trcking tool? Ans send to pbr.qtp@gmail.com

1 Answers   Cap Gemini,


In a WebTable 2nd row,3rd column contains one link and that link name is changing dynamically. How you will click the link?

1 Answers   Bank Of America,


does test plan is in test strategy or test strategy is in test plan

2 Answers   Tanla Solutions,


What are the different types of action?

0 Answers  


Categories