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 is difference between run time object and test object?
Please provide specific examples of advanced/creative usage of QTP, including how impact & benefits for your project
How many types of actions are there in quicktest professional?
I created 3 actions in test suppose I want to run action 1 in single time, action 2 is 4 time what I do?
Tell me about your project? please help me how to tell about insurance project
What are the disadvantages of recording test cases in qtp?
Hi,All How to create a link in excel sheet using qtp
What are the general steps involved in the data driven framework?
diff between qtp versions from 8.5
What is the descriptive programming?
How to test fly out menu in qtp?
What is action split and the purpose of using this in qtp?
What is expert view and keyword view?
Explain the concept of object repository and how quicktest professional recognises objects?
Hi All, How to get repeated word in string . Thanks Balaji