Answer / ravi

QTP supports interaction with Database using ADODB.

Set con = createobject("ADODB.Connection")
Set rs = createobject("ADODB.Recordset")

'Create DSN(DataSourceName) for your database and specify
the DSN here
'You can also establish connection using Provider name

con.open "DSN=MyDsn;UID=ravi;PWD=sample123"

con.execute "Insert into emp values(2500, 'Ravi')"

'Retrieve data from database
rs.open "select * from emp", con
while not rs.eof
msgbox "ID = " & rs(0) & " Name = " & rs(1)
rs.movenext
wend

Answer / m.s.patil

You can write OLEDB script:

Set Con =CreateObject("ADODB.Connection")
ConString="Provider:SQLNCLI;Server=plantdev;DataBase=QAServe
r;UID=patil;PWD=password1"
Con.ConnectionString=ConString
Con.Open

what r the send key commands in QTP why they r used

1 Answers  

---

what is run action?

0 Answers  

---

How does you pass optional arguments in qtp?

0 Answers  

---

Today only i joined in this site. Can u please tell me definition of parameterization. and how i can do the parameterization?

4 Answers  

---

if we can find the status of script in qtp that either it's pass or fail then why we need to put this status on different excel file or log file in hybrid framework .please let me know asap thanks

1 Answers   iCreate,

---

How to capture a window in QTP?

0 Answers   IBM, Mphasis,

---

how to capture tool tip in QTP and which check point is needed

2 Answers   Syntel,

---

what is delay in QTP?

2 Answers  

---

What is throw Object?

0 Answers  

---

What is the Difference between current version of QTP and QTP 8.2. Pls kidly Anybody let me know. Thanks in advance.

1 Answers   TCS,

---

How to insert a check point to a image to check enable property in QTP?

1 Answers  

---

what is the default ordinal identifier.what are the send keys in qTP.

1 Answers  

---