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