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

does test plan is in test strategy or test strategy is in test plan

2 Answers   Tanla Solutions,

---

How to call .vbs functions in QTP? plz Explain indetail

4 Answers   Wipro,

---

Write the script to delete the mail which is at 9th,13th and 18th place in INBOX of Gmail ?

0 Answers  

---

Can u Reduce the size of Object repository? What are the problems u have faced in Qtp tool?

2 Answers   IncRev,

---

What are the different recording modes?

0 Answers  

---

Hi.. I want to do parametrization for selecting perticular flighr say XYZ by using local table: criteria: 1.If flight is available msgbox "Flight is available" and then select flight from flight table and click to ok button after that as enter username and ticket no and then stop 2. otherwise msgbox " Flight is not available" and stop Please help me out ..and let me know your responses on dipak.bachhav@gmail.com Regard, Dipak

0 Answers  

---

How to measure transaction time through VBScript without using start and end transaction points?

0 Answers  

---

Idid my qtp course in 2007 june in mind Q i for got to use this tool ,i want to mention in my resume about this ,how can i rectify this ,pls give me any idea .

2 Answers   Quest,

---

what is the another name for blackbox testing?

7 Answers  

---

what is a file system object in QTP

7 Answers  

---

How many types of Automation frameworks are there in UFT? Describe them.

0 Answers  

---

write script for "dropdown button having how many words? for ex.SELECT CITY is dropdown name.. find out how many cities in that?

1 Answers  

---