Interested to Buy Any Domain ? << Click Here >> for more details...
How to connect to oracle(sqlserver) database to QTP
- 3 Answers
- 11172 Views
- CTS, I also Faced
- E-Mail Answers
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 enhancements u did after recording ur script?
How do u fetch data from a database ?
hi friends can any one provide me the project in qtp because i have to attend to interview within one week atleast you provide the website address which provide the qtp projects
Explain about random testing of 500 test cases?
what skills needed to be good test automation?
How many types of recording modes in qtp? Which will be used when?
there are having 10 checkboxes..how can i check only first 5 check boxes by using descriptive programing..
how will u do database testing in qtp? how will u do the same with descriptive programming?
what is input pramater out output pramater ?i want the decrepation..?how to use in QTP?
3 Answers Infinite Computer Solutions,
What is action? How many types of actions are there in qtp?
Explain how you can find length of array in qtp?
how can we retrieve ten rows from the data table using loop concept?
WinRunner 
