Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Difference between test object and run time object?

1012


How many types of run modes are there in qtp?

1034


Could i know how how to explain keyword driven framework in interview? If any body knows plz send the explanation.

2171


Anybody plz give, How do you test aframe in a web page? If page cotain text message or Images, tables?

2078


Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

2022


can any body clearly explain about keyword driven framework .give me the explanation for files what ever you use in this frame work?

2118


suppose in the middle of the project QTP will not work properly, then what do u do? and ur team?

1845


How to suppress warnings from the test results page?

1042


How will you handle java tree in qtp?

1116


Hi , I am facing issue QTP 10.0 with oracle ERP 11i .When QTP opens,click sub links on ERP ,FORM is not opening getting unexpected Internet explorer error message with send or don't send report.So unable to work with forms using QTP.

3869


Step 3&4 are repeated until an the object in recognised uniquely.

2033


How you are developing the script? Using record and play back or manual?

1070


How often were they executed?

2459


"What are the common constrains that we need to consider when we prepare testcases for ASP application". Thanks in Advance...

2005


Explain how you can find the absolute value of the number in qtp?

1097