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 you know that a test case is a regression test case

4006

---

how can we do the frame work in qtp

2076

---

how to use the QTP choose the data from oracle？ e.g. i input the identity card NO. this will be add new record in the database ,and now i want get this record's prime key.

1778

---

How reliable are the site's Internet connections required to be? And how does that affect backup system or redundant connection requirements and testing?

1260

---

Can I change properties of a test object?

1151

---

give me the code to save all messages of inbox of gmail into a folder and notepad

2117

---

How to handle dynamic objects in quicktest professional (qtp)?

954

---

Hi, I have 2 dropdown listboxes called region and city/area. It needs to select one region(Santa Clara) and one city/Area (Sunnyvale).So I put this in the for loop and I am storing the Items in the variable called itemname. The regions value will get changed,so I used reg expression for this regions. This is my code Browser("MLSListings.com").Page("MLSListings.com").Link("» County/Area").Click Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Check CheckPoint("regions") ListSize=Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetTOProperty("items count") For i = 1 To ListSize-1 Itemname =Browser("MLSListings.com").Page ("MLSListings.com").WebList("regions").GetItem(i+1) Browser("MLSListings.com").Page("MLSListings.com").WebList ("regions").Select Itemname ................. If I run the script,I am getting the following error, Cannot identify the specified item of the regions object. Confirm that the specified item is included in the object's item collection. Any Help? Thank you, Uma

1787

---

i have asked earlier only one question how to test web application using QTp plz send me the answer quickly

2139

---

Explain process of smart Identification in QTP?

1063

---

what is the frame work in J-meter?

2150

---

What are the Test design techniques you uses in ur project?

1971

---

Which scripting language used by quicktest professional (qtp)?

1151

---

Explain the concept of object repository?

991

---

what is the difference between IE & Netscape in web testing on a log in page

2319

---