How to connect to oracle(sqlserver) database to QTP
Answer Posted / 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 |
Post New Answer View All Answers
What are the different recording modes?
What is quicktest professional window?
write a script for allinterview-submit Question first we've to select Choose Category,second select Sub- Category(Which is comes in to runtime)third select Question Type.for that give some descriptive and vb script
Explain the difference between check point and output value?
tell me exact differenceb bw qtp and selenium?(could not tell open soure and licennce? difference in usage and technical difference?
How many add-ins comes by default with quicktest professional?
How are actions and functions different in QTP?
How we can import data from database?
write a script to validate the content in the web application. (do it by OR method) and (do it by Descriptive method by creating a description object..
What is the syntax to call one action in another?
If I give some thousand tests to execute in two days what do you do?
How do you test DLL files using automation Tool QTP?
What processes will be required to manage updates to the web site's content, and what are the requirements for maintaining, tracking, and controlling page content, graphics, links, etc.?
How do you open adobe acrobat file in QTP and do some testing on that file ?
What is checkpoints for quicktest professional?