how we connect oracle or sql data server database to qtp.
Answer Posted / ram
open qtp-->click record
In Insert Menu-->OutputValue-->Database Output value--
>select specify query manually radio button-->and click at
create button->click new-->select sqlserver from the popup
and click next-->next
u will get connection
DSN=database;UID=username;Trusted_Connection=Yes;APP=QuickTe
st Professional;WSID=computername;
and write sqlstatement
select columnid from tablename (dont put * instead of
columnid)
then automatically the below line is added in qtp
DbTable("DbTable").Output CheckPoint("DbTable")
and do remaining stuff.
u need some more clarification please send the mail to
i.krishna@rediffmail.com
| Is This Answer Correct ? | 10 Yes | 8 No |
Post New Answer View All Answers
Explain how you can find the absolute value of the number in qtp?
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
What is checkpoints for quicktest professional?
in qtp 3 sheets is there in data table like global, action1, action2. I want to check the rows and columns in action2. how can check using script?
Hi Friends, Im planning to do certifcation in mercury Automation Tool QTP.But I Didnt get any clear details regarding course syllabus, fees, where to approach, and which certification would be useful for the experienced testers? can any one send me the details?
I need to pull the data from the page which in row, column vice into excel sheet, how can it be done using QTP? eg: Name Dept xyz gdty i need the same data to be exported in excel sheet.
before launching qtp, we need to close all the open browsers u dont know what are all the browsers either it might be ie,mozilla etc and u dont know how many brosers are open.... u need to close all these before launching qtp.. can anyone plz temme d solution...
What is recovery scenario in qtp?
one screen page,that contains file , browse , update and cancel buttons.when we browse a file it should get update otherwise it should go to previous page.write negative test case for that.
if our qtp vb Script may be Currepted then What we want do?
What is object spy in quicktest professional (qtp)?
How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?
Did the scripts need lot of maintenance? If yes, why?
There is an built in window application in qtp9.1,i.e.Flight4.0.i want to implement the recovery maneger on it.How can i do this?
wht type of User defined functions or Java Releated functions Do we write in VB scripting