Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> open an ms-access data base from oracle using Generic Connectivity with ole-db
hi,
i try to do what the manual says but it doesn' work, some one can help me please?
what i have:
# LISTENER.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools.
SID_LIST_IEST =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = IEST)
(ORACLE_HOME = C:\oracle\ora81)
(SID_NAME = IEST)
)
(SID_DESC =
(PROGRAM = hsolesql)
(SID_NAME = vila)
(ORACLE_HOME = c:\oracle\ora1)
)
)
IEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverbd)(PORT = 1521))
)
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora81\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.
IEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverbd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = IEST)
)
(HS = OK)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = serverbd)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = IEST)
(PRESENTATION = http://admin)
)
)
and of course a file called initvila.ora with the path to the udl-file... Received on Tue Jun 29 2004 - 05:01:23 CDT
![]() |
![]() |