Home » Open Source » Programming Interfaces » ODBC connection problem
ODBC connection problem [message #249403] Wed, 04 July 2007 06:20 Go to previous message
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: how to connect to Oracle from jsp page in Eclipse?????
Next Topic: Can not connect to Oracle 10g with PHP 4.3
Goto Forum:
  


Current Time: Thu Mar 28 04:27:45 CDT 2024