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

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"

i have to prepare qtp certification course. so, please send me qtp tutorial notes.

1 Answers  

---

Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..

0 Answers  

---

Test script is generated and it is enhanced.It is required to be saved.But the disk space is insufficient.You are not permitted to delete any scripts.How are you going to save?

1 Answers   Accenture, DELL,

---

What is keyword view and Expert view in QTP?

9 Answers   Ordain Solutions,

---

Which Databases supports for QTP?

3 Answers   CTS,

---

I have 1 to 10 action are there, i want action1 output becomes to action 10 input? pls any can give script for this scenario?

5 Answers   AZTEC,

---

What is recovery scenario manager? When you go for recovery scenario manager?

0 Answers  

---

tell me about regular expressions in QTP? where we use? give eample?

2 Answers   IBM,

---

How may types of defects identify application or your currently working application?pls give me answer..

0 Answers   Cap Gemini,

---

What is operator in VB Script?

1 Answers   IBM,

---

What is the difference between low level recording and virtual object.

2 Answers   Tech Mahindra,

---

Why do we use "Text checkpoint" If we can make use of it in "standard checkpoint" ?

0 Answers   IBM,

---