Answer Posted / adarsh (saama technologies)

set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing

Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

1564

---

Mention the test steps of qtp.

949

---

Explain in brief about the quicktest professional automation object model?

891

---

what could go wrong with test automation?

2000

---

Hi all, I am using windows vista, I am in the process of learning QTP. When ever I try to work with insert mode in flight application , i am getting the error of 'Operation must use an update table query, fractional truncation(null) error. Can anyone help me regarding this?

1843

---

RECENTLY I PLACED IN QTP..HOW TO IMPROVE VB SCRIPTS KNOWLEDGE? IAM STRUGGING TO WRITE THE AUTOMATION SCRIPTS? ANY BODY TELL HOW TO IMPROVE QTP SCRIPT SKILLS?

2626

---

What is the difference between local and shared object repository in qtp?

991

---

How to save your test using quicktest professional?

980

---

Both static and dynamic arrays are handled by the vb script. Is it true?

978

---

Explain about datafile/verification of date file when file is not available in local system?

2670

---

What are the steps involved in recovery scenario wizard?

930

---

.have you ever written compiled module? if yes , tell me about some of the function that you wrote.

2124

---

Hi All, How to get repeated word in string . Thanks Balaji

1299

---

What is the difference between rational rose and QTP?

2187

---

How can we extract data like "Details","Result","Time" from the 'Run Error' result generated in QTP after run time errors are generated during a run & import the details etc...into excel sheet

1978

---