Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
connect oracle to QTP
#5
Solved: 11 Years, 3 Months ago
Hi,
You can do like this.
1)Create a Data Source name by following these steps.
Control Panel...>Administrative Tools...>Data Sources(ODBC)
Click on Add...>Select Driver Microsoft ODBC For Oracle Database
and follow the screens and then use the following code.
2)Paste the following Code in the QTP Expert View Window

Connect to the flight 32 database
Code:
Set Conn = CreateObject("ADODB.Connection")
Set Rs = CreateObject("ADODB.recordset")

Conn.Open("DSN=dsnname")
Reply


Messages In This Thread
connect oracle to QTP - by sherinvg - 02-26-2008, 12:51 PM
RE: connect oracle to QTP - by priyankmg - 03-14-2008, 04:07 AM
RE: connect oracle to QTP - by sherinvg - 03-14-2008, 01:50 PM
RE: connect oracle to QTP - by idolast - 06-24-2008, 03:22 PM
RE: connect oracle to QTP - by somisays - 06-24-2008, 05:49 PM
RE: connect oracle to QTP - by idolast - 06-25-2008, 02:42 PM
RE: connect oracle to QTP - by somisays - 06-26-2008, 12:22 AM
RE: connect oracle to QTP - by idolast - 06-26-2008, 03:28 PM
RE: connect oracle to QTP - by idolast - 06-27-2008, 12:18 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Getting error while connecting from qtp to oracle sql developer. Ritanjali Pradhan 1 3,170 09-26-2014, 02:06 PM
Last Post: vinod123
  Not able to connect to Oracle SQL Developer Paras Singh 0 6,753 05-30-2013, 01:25 PM
Last Post: Paras Singh
  Choosing Add-ins in QTP When Oracle forms or other IDEs used in web based application QTPBeginer 0 2,599 03-27-2013, 11:06 PM
Last Post: QTPBeginer
  Connect to QC ravi.gajul 3 14,689 09-18-2012, 12:39 PM
Last Post: SrinuKodi
  QTP API to connect to Performance Center(ALM) as_srini 3 5,690 06-14-2012, 09:14 PM
Last Post: Ankesh

Forum Jump:


Users browsing this thread: 2 Guest(s)