Home » RDBMS Server » Networking and Gateways » owb integration with db2 (oracle 10g)
owb integration with db2 [message #313887] Tue, 15 April 2008 01:07
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
Junior Member
I have created a system dsn named : TB700IP1

And my INIT.ora file look like this: and i have named it as initTB700IP1

# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent. 
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = TB700IP1
HS_FDS_TRACE_LEVEL = 0

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>


And my Listener.ora file:

# listener.ora Network Configuration File: E:\oracle\product\10.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENERTB700IP1 =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=ibexiHp21)(PORT=1521))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
 
SID_LIST_LISTENERTB700IP1=
(SID_LIST=
(SID_DESC=
(SID_NAME=TB700IP1)
(ORACLE_HOME = E:\oracle\product\10.1.0\db_1)
(PROGRAM=hsodbc)
)
)


And my tnsnames.ora file look like:

# tnsnames.ora Network Configuration File: E:\oracle\product\10.1.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

TB700IP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = TB700IP1)
)
(HS = OK)
)


Is it necessary to keep the listner.ora and tnsnames.ora files which references orcl sid..

so please let me know how to connect it ..
if you have any documents regarding this
please help out in this it has really taken my weeks time still not solved

regards
arvind
Previous Topic: Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Next Topic: Connecting to db2 source from OWB through Generic connectivity
Goto Forum:
  


Current Time: Sat Nov 09 13:31:23 CST 2024