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
Is it possible to split an action? How?
How to modify the text checkpoint?
How to suppress warnings from the test results page?
Explain the types of properties that quick test learns while recording?
What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????
How is a Step generator used in UFT?
How many types of parameters are there?
If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?
Both static and dynamic arrays are handled by the vb script. Is it true?
Hi Sudhananda, plz send me the QTP framework with any diagram and PPTS . I want to switch to automatio, I done QTP from professional person, but he does not give me his knowledge properly. so pls help me Thaks send me on following address mirajkar.akash@gmail.com
is it possible to add sheets to excel at runtime
What are the types of object repository?
What are the different recording modes and how do they work?
How to use output values in qtp ?
Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project