How will u integrate oracel with QTP?

Answers were Sorted based on User's Feedback



How will u integrate oracel with QTP?..

Answer / ganesan

1. create DataSourceName (aka DSN name) using "Oracle in
OraHome92" or "ODBC Driver for Oracle".

2. Select DSN name, UserID/Password to establish connection
to Oracle DB.

3. Create your own query to extract data from Oracle DB or
create DB-Check point.

Hope this will be useful for you. Good Luck.

-Ganesan.

Is This Answer Correct ?    2 Yes 0 No

How will u integrate oracel with QTP?..

Answer / naveen magatapalli

dim cmd
set cmd=createobject("ADODB.Connection")
cmd.open "Provider=ORAOLEDB;server=server_name;database=data
basename;userid=scott;password=sa"



IS it correct na if not then correct me.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More QTP Interview Questions

For Passing Parameters from one Action to another Action we will use Input & Output parameters. Can any one tell how to use this Input & Output parameters with Example ?

2 Answers   TCS,


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.

0 Answers   RR Donnelley, RRDonnelley,


If already everything is tested using White-Box testing, then what is the need of using Black box testing?

3 Answers  


why the smart identification is not there in WinRunner

1 Answers   DigiTech,


How can we redirect QTP results in to a excel sheet after the execution

3 Answers   SAP Labs, Virtusa,






Hi any body can tell me the synchranization point syntax thanks in advance

6 Answers   AppLabs,


How can I generate customized logs in QTP ?

2 Answers   Ordain Solutions,


Iam trying to write script for Rediffmail Page,in doing so the script line for go button is not accepting. Is their any other way other than . Browser("micClass:=browser").Page("micClass:=Page").Link ("micClasss:=Link","name=go")

2 Answers  


suppose there r 10 action in a test i want to execute action 5 to 10 how would i do that

2 Answers  


How many add-ins comes by default with qtp?

0 Answers  


In My application, having Copmany Name : Text Box and click Save button. if i enter a vlue, after run..........it shows the already exists. so how to enter random ro mmultiple names names into webedit box(company Name). without using DATATABLE THanks Ramesh

4 Answers   TCS,


i'm using QTP 8.2. A person using QTP 9.0 sends me a QTP TestScript, same when i try to open , an error comes "unexpected file format". Why?? and how to resolve the problem??

2 Answers  


Categories