Interested to Buy Any Domain ? << Click Here >> for more details...
how we connect oracle or sql data server database to qtp.
- 4 Answers
- 30192 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mohit
You may try:
Dim rs,sq,pkey
set conn=createobject("adodb.connection")
set rs=createobject("adodb.recordset")
' Oracle client is required to be installed on your box
conn.open= "Provider=OraOLEDB.Oracle.1;Password=***;Persist
Security Info=True;User ID=****;SERVER=****;Data
Source=****;DBQ=****;"
sql="your sql"
rs.open sql,conn
rs.close
set rs=nothing
conn.close
set conn=nothing
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Write the code for,In the page screen we have total 10 Links,out of these I have to click 9th link
How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?
How will you test a keyboard?
What is a reusable action?
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 the element we r test for QTP... explian clearly with example
What are the types of properties that quick test learns while recording?
hi in real time who will execute the qtp test scripts? my faculty said, in a companty automation testers are written the test scripts and manual testers are execute the test scripts...IS IT RIGHT OR NOT?
What is method name to compare two XML files.
How can we import into Excel "Details" ,"Result" ,"Time" parameters from within a Results Report which is generated after a Run error when a script is executed in QTP? Refer E.g below Status Functionality Description RunDate Fail Login User should be able to Login 12/3/2007 StartTime EndTime Details* 1:31:58 PM 1:32:29 PM (this one i want)
Explain the difference between check point and output value?
What are test settings and global settings?
tell me QTP standards ?plz
What are the recording modes in wave event?
Hello Everyone, Please provide me the practical example of business component concept of QTP.Like how to create business component,how to connect the quality center etc.... Thanks in advance, Gaytri
Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.
