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


Please Help Members By Posting Answers For Below Questions

If I change the property value at runtime is it effect is object repository?

595


how to test Web application using QTP software

1323


If object is not recognized by qtp but the object is standard object what is your approach?

581


They asked by using qtp recording writing scripting

2058


how to find that tools work well with your existing system?

1397






What are the advantages of parameterization ?

587


I recorded a Web App with a Oracle backend using QTP 9.5 and for some reason the scripts don't play back> What am I missing at this point. I recorded the same Apps under Sybase and they work great. This is Oracle 10g. Why won't my scripts play back.

1500


Explain in brief about the qtp automation object model (aom).

550


What is the short cut keys for the following?

632


Hi could some one explan what is the use of the function Defination generator, And how to use the function defination generator.. Explan with the example..

1339


descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button

1797


what are the mandatory properties for a tex boxc (scenario?)

1520


Thanks....But can u tell me how i use the QTP for GIS with one Example...

1416


Which HTML specification will be adhered to? How strictly? What variations will be allowed for targeted browsers?

549


I am sathish , i want to test the Application of JIL.org ,Mobile Emulator ,by using QTP10.0. I am trying to do testing on that Application , but Child Objects are not identified by the QTP. Please can any one help me

1416