| owb integration with db2 [message #313888] |
Tue, 15 April 2008 01:13 |
aravindmech
Messages: 7
Registered: April 2008
Location: bangalore
|
Junior Member |
|
|
can any body help me out how to solve this
is it necessary to keep the orck sid along with db2 sid in listener and tnsnames.ora files..
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)
)
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
