Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> open an ms-access data base from oracle using Generic Connectivity with ole-db

open an ms-access data base from oracle using Generic Connectivity with ole-db

From: invited <invited_at_yahoo.es>
Date: Tue, 29 Jun 2004 12:01:23 +0200
Message-ID: <PfbEc.292779$Rc.9169922@news-reader.eresmas.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US