How to connect to oracle(sqlserver) database to QTP
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / adarsh (saama technologies)
set con=createobject("ADODB.Connection")
set rs=createobject("ADODB.Resultset");
con.open"provider=oraoledb.1;server=
(servername);UID=(username);PWD=(password);DB=dbserver"
rs.open query,con
Do while not rs.EOF
i=0;
msgbox(rs(i))
i++
rs.move next
loop
rs.close
con.close
set rs=nothing
set con=nothing
| Is This Answer Correct ? | 1 Yes | 2 No |
what are the challenges do we face while testing webbased applcations using the automation tool QTP or any?
w is output value
Can any one tell the different properties and values of differnt objects like Browser,Page,link,webedit,webcombobox,webradio botton,webcheckbox and web button.Because I am facing a lot of problems in interviews with Descriptive Programing.I never worked on web Application...Pls help any one as soon as possible....
How to retrieve alpha bate from the alphanumeric string with special character.
How do we handle run-time errors?
How to start recording using quicktest professional (qtp)?
In qtp, how you can get the last character from a string?
What are the views available in qtp?
What are the technics follow in writing VB script?
How can i learn Descriptive programming in QTP. Please reply.
Can u tell me example for virtual objects?
How to make Shared object repository in qtp 9.1 and 9.2?