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
Hi any body pls help me for QTP 11.0 software free demo version. i have to practice. Kindly send the link.or where i have to download.
How should I click on the right click menu objects When I trying to add the object properties to the OR.It is showing only Window(Window).Not all the objects of the window. Also while recording I found No script. How to solve this>.
What is difference in global and action sheet in qtp?
How to handle the exceptions using recovery secnario manager in quicktest professional?
what is the difference between data driver & data driven and driver script?
Does Low-level recording capture mouse movements?
how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief
Without using gui map editor we can recognize the application in winrunner ?
If you are testing a web application then what will you test in that application?
Can any one send me the QTP Basic Coding Samples?
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?
can u explain relative path architecture framework in qtp?
QTP 10.0 is not identifying web objects for IE 8.it is identifying like winObject.I installed HP patch QTPWEB_00037.Still getting issue
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
what is keyword driven testing in qtp?n how is it useful?