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
How to use the object spy in quicktest professional (qtp) 8.0 version?
What is the syntax to call one script from another?
Explain how you can find length of array in qtp?
What are the methods of the TextStream object that are used for reading from a text file?
In qtp, how you can remove the spaces from string?
How to analyzing test results using quicktest professional?
Can we write winrunner language i.e TSL in QTP tool?
What is difference between Recording time object identification and Run time (Execution) time.
How you can decide which type of object repository you have to use?
www.icici.com ,after this.. home page wll came, in this page what r the items we r going to test for manual and what are items we r going to test for QTP... explian clearly with example
I have many listboxes in my application. I have to check whether the contents inside the listboxes are in sorted order or not..can anyone please send the code as early as possible
What kinds of security (firewalls, encryptions, passwords, etc.) will be required and what is it expected to do? How can it be tested?
Is it possible to refer the same object for referring more than one object that are of different class using the descriptive programming approach? Suppose my code is 'To create the object named as obj Set obj=Description.Create() 'To define the values obj("title").value="IE" obj("type").value="text" obj("html tag").value="INPUT" 'To set the value Browser("IE").Page("Yahoo").WebEdit(obj).Set "xyz" Can I refer the "obj" object for the three objects like Browser,page and webedit objects? If so how?
can test automation improve test effectiveness?
How to run a test using quicktest professional?