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
explain abt dyanamic changing object with example?
How can you handle exceptions in qtp?
What is the recovery scenario in qtp?
What is the framework your company is following. What is the reason. Explain why key word driven frame work is chosen.
How many add-ins comes by default with qtp?
I want to do QTP Certification what is the pattern of Question paper.
How to remove the associated function library?
Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks
What VBScript operators, functions, and statements do you use in QuickTest Professional?
What are the steps involved in the recovery scenario wizard?
What is the pros and cons between QTP and Rational Robot
How many types of recording facility are available in quicktest professional?
What is the syntax to call one action in another?
Describe how Smart Identification is used
Is it possible to call win runner script in qtp?