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

Hi my name is mohan. I am working as a manual tester.. And now i want learn QTP.. is there any online websites to learn QTP for free if u know any plz help me out..,.or send mail to k.mohann.mohan@gmail.com

3 Answers   Wipro,

---

Who is the best faculty for QTP in Hyderabad? Is it Mr. G.C.Reddy, some are referring his name?

21 Answers  

---

Explain xml checkpoints.

0 Answers  

---

How many function you use in your application?

2 Answers   Polaris,

---

Explain about Test Fusion Report of QTP?

0 Answers  

---

when you press a link it displays "the page cannot be displayed" then as a tester how you will find the problem,what type of problem must be it?

3 Answers  

---

What is the differnce between action & script

2 Answers   Lehman Brothers,

---

how you have used object libraries? plzzzzz do answer

1 Answers  

---

1.what is the difference between childobjects and child items in qtp? 2.what is difference between a class and function? 3.can u convert ustimings to indian timings using vbscript? 4.i have scripts in one machine.can i run those scripts in another machine.how?

2 Answers   Genpact, Infosys, Symantic Space, TCS,

---

tell me the script for envirnment value parameeter with an example. which situation envirnment valu parameter is used

2 Answers   HCL,

---

i have a window , initial its name is "NEW CUSTOMER" i have to enter the details of customer in the test object fields and after saving the window name is automatically changing with the customer name . so how to identify that window after saving. (i am using descriptive programming.)

5 Answers   Syntel,

---

How to add a runtime parameter to a data sheet?

6 Answers  

---