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

Among all the check points what is the most important checkpoint?

5 Answers   Semantic Space,


how we connect oracle or sql data server database to qtp

3 Answers   Tanla Solutions,


How to connect to oracle(sqlserver) database to QTP

3 Answers   CTS,


How do you export an output to a excel sheet? Ex: I get my answer by using Msgbox"..." &R. How do I displayed the result of the Msgbox (such as R) to an excel sheet? Please let me know.Thanks

2 Answers   ADC,


how to create external data table?

1 Answers   TCS,






How did you resolve conflicts present in Object Repository?

0 Answers  


What is the framework your company is following. What is the reason. Explain why key word driven frame work is chosen.

0 Answers   Value Labs,


How to enable the text check point in qtp? By default it is disables

1 Answers   Sify, ssinformatics,


qtp script for recording and running the application.need script for short cut keys like f3,f4 etc.how to write script for recording?

2 Answers  


what is syncurnisation point? what is the use of this in real time environment? plz explain?

6 Answers   AppLabs,


Is qtp supports uni-code?

0 Answers  


Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly

0 Answers  


Categories