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

Hi I know two types of testing processes. 1. Reaquirments stage,test design,code review's, Design review's, Test Plan, Test Cases design, test execution, Defect Reporting and tracking, UAT, Signoff. 2.Test Initiation , Test Plan, Test Design, Execution,Bug tracking, UAT, Sign off.

1800


What is the difference between byref and byval in qtp?

1009


iam working in QTP for 2+ of exp if i attend the interview what r questions asked in perfomence testing{loadrunner} ? pls any one can say answer to this question?

2030


we add library file used in test via settings or through "ExecuteFile" command. when we implement framework do we make common library file and load the same for all the test cases execution?

2161


Hi How to retrieve data from web element line by line?

1995


when u script reveiwing in which area u more concentrates?

1833


hi guys we r working in office...we write some scripts..suddenly we have a work(5min only) in out side..what will do now,,,used to system shut down or log off or lock or sleep mode,switch use or hibernate?

1981


i have asked earlier only one question how to test web application using QTp plz send me the answer quickly

2083


What is the difference between local and shared object repository in qtp?

992


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.

1856


What is difference between shared and local object repository?

1066


what is the diff between manual test plan document and automation test plan doc.can u explain indetail.

2054


How to recognise the webelement and verifying that webelement is enabled?

2119


How do you know the location Id of an object if you know its index id?

993


Hi ,Can any one pleas explain how to test splash objects using QTP?

2313