Interested to Buy Any Domain ? << Click Here >> for more details...
How to connect to oracle(sqlserver) database to QTP
- 3 Answers
- 11005 Views
- CTS, I also Faced
- E-Mail Answers
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 customize qtp?
UFT 12.02 which ALM version will support
how interviews will be on QTP?
What is smart identification in QTP?
Why is Client side image is preferred over server side image?
What are the factors on which script execution time is dependent?
Where to use Property Let, Property Get, Property Set in UFT
describe some problems that u had with automating testing tool?
Explain types of output values?
In Test Directory, What are the contents in test case designing? if you prepare in excel sheet how u use thrw Test Directory?
what is the hierarchy to use properties in descriptive programming
Hi Friends, I worked with 8.2 not with 9.2. Please help me in this prob. I created one script and recorded some think and save as Test 1 then I opened process--open the object repository manager. Switch to file->save->give some name->save as Objectrepo1.tsr file. (This is the global repository file.) Then I went to object repository->tools-> associate repository ->click + icon ->open the previously saved Objectrepo1.tsr file. This is the global repository Now I created one more script and save as Test 2. In this script I am calling script with the Help of "Call of existing action" and I executed but QTP is not able to execute B’cos it is QTP is not able to read the Object Repository of Test 1. Please let me know why? Once I made Script 1 as a shared Obj. Repository so it would not give any Problem. Right?
What is the diff between image and bitmap check point?
desribe a situation where u faced a stressful situation and how did u cope with it
What is the difference between byref and byval in qtp?
