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 |
Explain how you can find length of array in qtp?
What is the need and applications of learning VB script for a automation(QTP) engineer ain Realtime ?
How to get all the objects count and objects names in webpage using QTP ?
what is error and fault in terms of software quality?
What are the types of Object Repository’s in QTP?
Why do we go for Qtp? What are the advantages of qtp? Diff between winrunner and Qtp?
Hi we are using QTP9.0 for Seibel Application and this seibel application will give you a popup messagebox which is of web , so qtp takes 3 mins to recognize the messagebox and to click on it , we have more number of messageboxes like this . please suggest me some solution
Explain about the test fusion report of quicktest professional (qtp)?
How to return a value from a fn, if it has more than one value how to return
what frame work you are following?
How do you test DLL files using automation Tool QTP?
How to capture checkbox properties when properties of the object keep changing on relogin to the application.