hi friends i was tried to connect qtp with oracle database
using provider.i got a error.so anyone can help me out by
correct script
Answers were Sorted based on User's Feedback
Answer / shilpa reddy
I will provide u the code for it,try it once.
set con=createobject("ADODB.connection")
con.open "provider=oradb;server=Ipaddress;hoststring=stringn
ame;username=scott;password=tiger"
set com=createobject("adodb.command")
com.activeconnection=con
com.commandtext="ur required sql statement"
com.execute
| Is This Answer Correct ? | 0 Yes | 0 No |
what is a test strategy & what is the difference between test strategy & test plan?
what is option explicit? what is the use of it?
Explain in brief about the QTP Automation Object Model.
recording is not a good programming practice.How to write effective script without recording.Which is the correct method explain in detail
In Developer view it is a high priority defect & in tester view it is a low severity defect what is that how to define with an example
What is the difference between a Function and Action in QTP?
What is the difference between "Call to copy of action", "Call to existing action" & "Call to winrunner action"?
I installed QTP 9.5 on vista. Can someone please provide me the license key of the same. Thanks, Avi
Hi, i am rani ,i am putting 1+years of fake exp ,so pls anyone explain how i get project (in real time) ? how it is tested ex: in banking ,test the number of textboxes in one window
what is the hierarchy to use properties in descriptive programming
how can u find the syntax errors or other script errors in your test during the execution of your QTP Test - (i.e., not after the execution/test run finished, but before finishing the test run)
I am facing an issue of object identification with the dropdown element of DHTML grid. When I tried to recognize these different dropdown objects, QTP identifies only one object for all the dropdowns. Hence, selection of different data from different dropdowns list is an issue. To overcome this problem, i have used Descriptive Programming technique by creating different object descriptions which have all the other properties same but differ only in one property i.e. ‘X’ location of the element on the screen. Hence, i have created distinct object descriptions that would allow us to select values in different dropdowns. The code is given below. But still I am unable to identify distinct dropdown objects. ‘Object Description for Dropdown Cell Status Set objCellStatus = Description.Create objCellStatus("micclass").value = "WebList" objCellStatus("name").value = "select" objCellStatus("x").value = 219 ------ ‘X’ Axis value for cell status drop down ‘Object Description for Dropdown Sub Segment Set objSubSegment = Description.Create objSubSegment("micclass").value = "WebList" objSubSegment("name").value = "select" objSubSegment("x").value = "319" ------ ‘X’ Axis value for sub segment drop down Please help... This is specific to DTML grid(Drop down object)