| ODBC connection problem [message #249403] |
Wed, 04 July 2007 06:20  |
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
|
Junior Member |
|
|
Please help...
this is my Tnsnames.ora file
--------------------------------
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
INST1_HTTP.NFPCSPFAO.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)
EXTPROC_CONNECTION_DATA.NFPCSPFAO.LOCAL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
MPB.NFPCSPFAO.LOCAL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez) (PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = MPB.Pervez)
)
)
access_db.world=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP) (HOST = MPB.Pervez) (PORT = 1521))
(CONNECT_DATA =
(SID = hsmsql))
(HS = ok)
)
THis is the lisnter.ora
-------------------------
# LISTENER.ORA Network Configuration File: C:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = Pervez)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = hsmsql)
(ORACLE_HOME = C:\oracle\ora92)
(PROGRAM = hsodbc)
)
(SID_DESC =
(GLOBAL_DBNAME = MPB.Pervez)
(ORACLE_HOME = C:\oracle\ora92)
(SID_NAME = MPB)
)
)
and this is inithsodbc.ora
---------------------------
# 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 = <odbc data_source_name>
# HS_FDS_TRACE_LEVEL = <trace_level>
HS_FDS_CONNECT_INFO = testdb
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
------------------
The user dsn name is testdb and the driver is microsoft access driver.
i am using oracle 9i, sql * plus..
i don't know what i am wrong but couldnot connect to access database
please help me
|
|
|
|
| Re: ODBC connection problem [message #249556 is a reply to message #249403] |
Thu, 05 July 2007 00:46  |
mahbub
Messages: 4
Registered: July 2007
Location: Bangladesh
|
Junior Member |
|
|
one thing i should mention here...
everyday when i start sql*plus with scott/tiger, it gives error message 'shared memory realm doesnot exists'
what i do is Run the Database configuration assistant, after finishing the wizard, it says nothing is configured. But after running the wizard i can run sql*plus with scott/tiger!!!
can anybody helpme out what's the problem is?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
