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
How will you check that your test cases covered all the requirements?
if mandatory and Assitive propertys are shows same how will u write skript in QTP window
i have a doubt can anyone tell me where are scripts stored while using QTP.Tell me the exact procedure takes place in real time?like how we call scripts how to proceed after writing scripts?how scripts are executed etc?i heard some use Qc whether others dont use.so tell me whole procedure for both the things it will be a very big help.as i have interview i want to have whole idea on this.its very urgent.
What test you perform mostly? Regression or retesting in your testing process?
can any body tell me how i create a simple script and apply output value on it .pls send me a step by step process
Can anybody let me know how to test the Drag and drop feature of the column in a .net application...eg..i hav to test the drag and drog feature of a table(swftable) in a application..plze help!!
what kind of frame work you used in your last project?
What does mean by Scope of Automation?n How we defined it?
Explain the N-tire structure(process) for Funds Transfer ( means give N ways to funds Transfer in an Application)
Is QTP supports Unix. If yes, then how the test automation is done?
I am a new tester that needs to create an automatic script involving security questions. On a webpage I need to select a security question(which are random) from a drop down menu, and then input the answer as the last word from the security question. I have the script set-up to automatically select the first security question from the drop down. The problem I am having is trying to insert the security answer. How do I insert the security answer based on the selection from the security question?
how to find that tools work well with your existing system?
How to execute the WR Script through QTP? I have WinRunner script with initialization script, common scripts, GUI AND functions. I connected WR through QTP with "call to WinRunner" option but I am getting problem after connecting to WinRunner i.e. showing "Do you want to quit now" with 'yes' and 'No' message box
How to test fly out menu in qtp?
What is expert view and keyword view?