How to connect to oracle(sqlserver) database to QTP
Answer Posted / madhumitha
we can connect to oracle database throught conntection
string....
code for connecting to db
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Recordset");
con.ConnectionString="DRIVER={oracle in orahome92};SERVER=
(servername);UID=(username);PWD=(password);DBQ=dbserver"
con.open
query="select * from tablename"
rs.open query,con
while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
wend
rs.close
con.close
set rs=nothing
set con=nothing
any coments always welcome
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what frame work you are following?
your coming from electrical backgroung..but y ur coming to software side?
How do you create new test sets in td?
What are the types of properties that quick test learns while recording?
I used child objects to get the no of weblist present in the weblist.now i need to select the items present in each weblist ?How to do so
Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?
Hi How to retrieve data from web element line by line?
What does mean by Scope of Automation?n How we defined it?
what is description object?
Tell me one scenario, the complex functionality you have automated in your project?
action contains public and private functions but do we resuable that action or not..If it is reusable How..plz tell me the ans
Where we can use the synchronization?
how we connect 1. qtp9.2 to the quality center9.0? 2. Load runner8.0 to the quality center9.0
What is difference between shared and local object repository?
explain how to write vb script in qtp?when will you write own script?