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

How can you merge two Object Repositories?

3 Answers  


When to use Descriptive programing?

2 Answers   Wipro,


What are the challenges u faced in testing with crm domain? How u overcome with?

0 Answers  


Hi, Any one have the crack for QTP 10.0,if so could you please send it to phanijuly10@gmail.com

2 Answers  


What are the enhancements u did after recording ur script?

3 Answers  


how to merge object repositories?

5 Answers  


Explain different type of event trigger option.

0 Answers  


How to invoke QTP using Dos prompt ?

2 Answers   ABC,


Hi, I Need code to click the webbutton inside of webtable. I need to click a particular 'Edit' webbutton inside of webtable. For Example... Having 5 Rows and 10 Columns. 'Edit' webbutton are placed in 10th Column. I need to click the 3rd row 'Edit' button with unique value. Browser("....").Page("...").Frame("...").WebButton("btn_Edit ") I Tried with below code: Set objButton = Browser("...").Page("...").Frame("...").WebTable("...").Chil dItem(3,10, Webbutton,0).Click - Not working this code :( Anyone can help me to sort out this simple issue ???

1 Answers  


hi i need to learn qtp its very urgent..pls tell me who is the best faculty for qtp in hyd..... and i plan to go foe mindq nageshwar rao? its good or not?

2 Answers  


1)what is the quality process in QTP? 2)how to add the .tsr file in qtp through scripting?

1 Answers   L&T,


what are the disadvantages in QTP 9.2?

1 Answers  


Categories