Answer Posted / mohit

You may try:

Dim rs,sq,pkey
set conn=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persist
Security Info=True;User ID=****;SERVER=****;Data
Source=****;DBQ=****;"
sql="your sql"
rs.open sql,conn

rs.close
set rs=nothing

conn.close
set conn=nothing

How to use the object spy in quicktest professional 8.0 version?

987

---

how to fetch the values from grid? & qtp recogniges that grid as a webelement? what u do?

2418

---

what are all the fileds present in object repository?

2044

---

What are the challenges you faced during you entire life automation ?

1519

---

What are the advantages of qtp?

1011

---

What is the pros and cons between QTP and Rational Robot

3780

---

If the objects hierarchy is changing from build to build, then how you will handle that condition?

1053

---

how u will evaluate the tool for test automation?

1855

---

What are the factors on which script execution time is dependent?

1068

---

What is environment variable in qtp and why to use it?

1010

---

any body can you help me what is the script to automate an comand promt

2491

---

Hi All , How can we decicde for pariticular frame(DataDriven or Keword Driven)in Project? Thanks Balaji

1830

---

How does you pass optional arguments in qtp?

1038

---

Can we use index on view?

2096

---

What are benefits of qtp?

1134

---