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, i run scripts in one machine those r passed.when i run the scripts in client side those r failed.Give me such a scenario when ever u faced?

0 Answers   BirlaSoft,

---

What is diff betwee datatable.importsheet "path" and datatable.import

2 Answers  

---

What is the difference between low level recording and virtual object.

2 Answers   Tech Mahindra,

---

Could any one tell me "How can i recognize my cursor position using QTP 9.2" Give me a scripts for this

0 Answers   Livetek,

---

How to test fly out menu in qtp?

0 Answers  

---

Give some brief idea about a) Active x check b) Alt property check c) Applet object check d) Frame object check e) Multimedia links check f) Server side image check g) Table object check

1 Answers   CTS,

---

What are the methods of the TextStream object that are used for reading from a text file?

0 Answers  

---

I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible

0 Answers  

---

How to send the qtp results file by email (Lotus notes).

1 Answers   TCS,

---

how to associate object repository during runtime in qtp

1 Answers   Deloitte,

---

How many types of status are there?

0 Answers  

---

Why bpt?

0 Answers  

---