Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Lightbulb Unanswered: Oracle with MS Access

    Hello, I'm trying to create a connection of my Oracle db with ms access, so I want to read some access tables from my oracle user, using an odbc connection and a dblink, I dont have information about It, can you explain me the process step by step or can you give me a document to do It ??

    I used to do It with a fox pro database, and now I don't know how to repeat the process with access.

    Thanks !!!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Heterogeneous Services - Generic Connectivity In Oracle9i
    Oracle9i, like previous versions, supports heterogeneous services to allow data
    in non-Oracle database to be queried using SQL. This support has been in the form
    of transparent gateways, which are vendor specific, or generic connectivity which
    uses ODBC or OLEDB to make the connections. The functionality supported by generic
    connectivity is typically more limited than that possible when using vendor specific
    gateways, but it is quick and simple to configure. The steps listed below can be used
    to connect Oracle to any ODBC compliant database (MS Access, SQL Server etc.) on the

    local server:
    Make sure a valid username and password are present for the non-Oracle database
    (MyUser/MyPassword).
    Create an ODBC DataSource for the non-Oracle database (Access1).
    Create a file called: ORACLE_HOME\hs\admin\initACCESS1.ora which contains:

    HS_FDS_CONNECT_INFO = Access1 #ODBC DSN
    HS_FDS_TRACE_LEVEL = OFF
    Add the following entry to the tnsnames.ora file:

    ACCESS1.WORLD =
    (DESCRIPTION=
    (ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521) )
    (CONNECT_DATA=(SID=ACCESS1))
    (HS=OK)
    )
    Add the following entry into the listener.ora file:

    (SID_DESC=
    (SID_NAME=ACCESS1)
    (ORACLE_HOME=D:\Oracle\Ora9011)
    (PROGRAM=hsodbc)
    )

    Reload the listener: lsnrctl reload
    Create a database link using:

    CREATE DATABASE LINK access1.world CONNECT TO "MyUser" IDENTIFIED BY "MyPassword" USING 'ACCESS1.WORLD';

    Query the table using:

    SELECT *
    FROM mytable@ACCESS1.WORLD;

    HTH
    Gregg

  3. #3
    Join Date
    Jun 2003
    Posts
    294
    I'm getting this error:

    ERROR at line 1:
    ORA-28545: error diagnosticado por Net8 al conectar a un agente
    NCRO: Fallo al intentar establecer la conexión RSLV
    ORA-02063: preceding 2 lines from CREDISEGURO

    Note:
    I have Oracle In the machine A and MS ACCESS in the machine B

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •