Answer / manish deshmukh

Set con = Createobject("ADODB.Connection")
set rs = Createobject("ADODB.recordset")
con.connectionstring="DSN=xyz;UID=abc;PWD=pqr;"
con.open
SQL="select * from manish"
Set rs=con.execute(SQL)

Answer / rangarao

Set myconn=CreateObject("ADODB.Connectionn")
myconn.Open
("Provider=OraOLEDB.Oracle;DataSource=Your_Oracle_Database;o
SAuthent=1;")
if(myconn.state=1) Then
Set rec=myconn.Execute("query")
while rec.EOF<>TRUE
msgbox rec.fields(colname)(We can also Specify column index)
rec.MoveNext
wend
End if
rec.Close
myconn.Close

Answer / bharanikumar . r

Hi all,

I had some idea about this question

Answer:

First we need to create the object for connection

ie.
Set a = Createobject("ADODB.Connection")
set b = Createobject("ADODB.recordset")

Then with the help of created object we will define the SQL
Query

For ex:
Opening the data from SQL:

step 1 - create the connectivity whether manually or qtp
step 2 - a = Select * from exmployee with the connectivity
with DSN

and we have to declare the array size also because once a
data retrieved from the database it will stored in array
format --

Thank u

In a shared Object Repository in QTP if some object is changed how can the other script which is using the same object can be known

6 Answers   iGate,

---

write the regular expression for date format of mm/dd/yy?

10 Answers   CTS, HCL,

---

write script for bitmap image?

0 Answers   CA,

---

any body want to learn qtp with real time concept on Banking domain contact ciraaj@gmail.com

1 Answers  

---

in flight reservation application. when i entered flyto combobox as london. and i have to check this london is present in flyfrom combobox.give me the code with good explanation. extention to this question. at each iteration i have to put(WRITE) the fly from and fly to city in database table

1 Answers  

---

What is object identification?

8 Answers   Wipro,

---

How can we check whether a particular sheet loaded (existed) or not in Data Table.

7 Answers   TCS,

---

How can I test the unix shell in QTP

2 Answers   Persistent,

---

What is the difference between check point and output value.

5 Answers  

---

How do you check ticket cost and ticket number in flight application?

0 Answers  

---

What is the difference between QTP 8.2 and QTP 9.2 ?

4 Answers   IBM, Infotech,

---

How to create Userdefined Function.Please write the steps ans also provide example where exatcly we use it.

1 Answers   HP,

---