Answer Posted / sunita

Dim sServer, sConn, oConn, sDatabaseName

sDatabaseName = "Migrations"
sServer = "hyrdwsz0010"

Set oConn = CreateObject("ADODB.Connection")
oConn.Open "provider=sqloledb;data source=" & sServer & ";initial catalog=" & sDatabaseName &";Trusted_Connection=Yes;"
oConn.CommandTimeout = 0

Set oRs = oConn.Execute("Select * from dbo.CLIENTLISTSS")
Set RowCount= oConn.Execute("Select Count(*) from dbo.CLIENTLISTSS")
Msgbox FormatNumber(RowCount(0),0)
Msgbox oRs.Fields.Count
Msgbox oRs.Fields.item(1)
arraydata=oRs.GetRows
Msgbox arraydata(1,1)

Explain about the test fusion report of quicktest professional?

1000

---

HOw to add the recovery file at runtime to the test file .

2252

---

How to handle dynamic objects in quicktest professional?

985

---

Hi Friends... By using QTP , can we test .net products...and that product supports different languages.. thanx in advance..

5051

---

Can we access the java methods in qtp. Because my requirement is to access the swt(for eclipse an it is java code) methods in qtp is it possible?

2082

---

How do I get the QTP scripts result in xml format by using vb script function?

2334

---

Explain calling sub procedure.

1119

---

Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

2058

---

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

2163

---

1. wat are the main diff b/w QTP 8.0 AND QTP 9.2 ( not user interface) 2. wat is the meaning of Keyword in keyword driven frame work? 3. how u will handle the unknown errors while exucution. (not recovery scenario)

2207

---

What are the different properties of an web object

1957

---

What is the default object synchronization timeout in qtp?

1271

---

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

1104

---

What environment does qtp run in?

1202

---

What is the extension of QTP local Repository? If it is .mtr then what is .bdb extension stands for?

1206

---