Answer / jayadev acharam

Using ADODB Object
Example
DB_Connect=CreateObject(ADODB.Connection)

Answer / akshay

Public Function database(Str,SQLstr,outResult1,outResult2)

'//Variable Declarations
Dim objConn, rsOut

'//Create a connection object.
Set objConn = CreateObject("ADODB.Connection")

'//Create a ResultSet Object to store the results.
Set rsOut = CreateObject("ADODB.Recordset")

'//Open the Created Connection object
objConn.Open Str

'//Pass the SQL query string and retrieve the Results
through the connection object
rsOut.Open SQLstr,objConn

If rsOut.EOF <> True AND rsOut.BOF <> True Then

'//Store the different column values
retrieved from a record in different variables.
outResult1=rsOut("col1")

outResult2=rsOut("col2")

rsOut.movenext
End If

End Function

how to retrieve data from flight resevation->reports

2 Answers   Wipro,

---

In qtp is it possible to check broken links of a page?

0 Answers  

---

Can we record an application running on a remote machine using qtp?

0 Answers  

---

Our company is having a windows client server application developed in vb.net. so there is a treeview and i am not in a position to record the click events in QTP. so kindly help. Vivek

0 Answers  

---

How to handle dynamic objects in QTP?

4 Answers   Infosys,

---

How to get popup error message.

0 Answers   Tech Mahindra,

---

how to insert QTP to display errors and other description in the test results instead of halting execution by throwing error in the mid of executin due to an error (for object not found)?

1 Answers   Ordain Solutions,

---

How many types of recording modes in qtp? Which will be used when?

0 Answers  

---

Can Any One Write How to Write the Script for Child Objects

4 Answers  

---

How vl i prioritize the actions when i have 10 actions A1, A2, A3......A10. I want to run action as follows A1,A5,A6 and A10. How i can do it. Thanks in Advance to u.

7 Answers   IBM, Wipro,

---

write vb script code to delete the duplicate values in an array.

4 Answers   ADP,

---

what is the smart identification techniqu?what r the different mechanisums used in it?

2 Answers   Accenture,

---