How to connect to the Database from QTP?
Answer Posted / ramireddy
Thru Self scripting:
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 ? | 25 Yes | 6 No |
Post New Answer View All Answers
What are the two types of repositories available, explain them?
Brief the process of testing with UFT?
Where we can use the analog mode and where we can use the low – level mode?
How to break the object spy ?
Explain different recording modes?
How can I change object description or check point values in qtp?
Did the scripts need lot of maintenance? If yes, why?
How to sendKeys in QTP? Diff b/w sendkeys and device replay? Diff b/w function and Sub? Diff b/w Array and List Different Types of running Keys other than Fast, slow,Normal mode Regular expression for http://newtours.demoaut.com Difference between \w and \W How to generate script button Recording Types Different Types of Actions? Using DP performance degrades, If Yes why? How to close all the opened browsers? Diff b/w SystemUtil.Run and invoke application? If qtp not recognized the combo box How to select values from drop down?
What is qtpro?
If I change the object name in one action will it be updated in all the actions? Or not?
can i compare two databases using QTP ?
Explain about the test fusion report of quicktest professional (qtp)?
How does you test a weblink which is changing dynamically?
when to start the automation?
With what extension you can save the list of tests in a file to run in test batch runner?