How to establish the database connection using QTP?

How can you create a test data in oracle and how to fetch the data from it? Explain it with an example.

Interview Candidate
Aug 8th, 2007
1
1535

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

anil

Aug 21st, 2007

we can connect to oracle database through connection string....code for connecting to dbset con=createobject("ADODB.Connection")set rs=createobject("ADODB.Recordset");con.ConnectionString="DRIVER={oracle in orahome92};SERVER=(servername);UID=(username);PWD=(password);DBQ=dbserver"con.openquery="select * from tablename"rs.open query,conwhile not rs.EOFi=0;msgbox(rs(i))i++rs.move nextwendrs.closecon.closeset rs=nothingset con=nothing