This discussion is archived
8 Replies Latest reply: Sep 23, 2012 10:47 PM by kgronau RSS

connect oracle64bit (linux) to access

narges Newbie
Currently Being Moderated
dose it possible to connect oracle 64bit(linux) to access?
what i must to install for that
  • 1. Re: connect oracle64bit (linux) to access
    Aman.... Oracle ACE
    Currently Being Moderated
    user498843 wrote:
    dose it possible to connect oracle 64bit(linux) to access?
    what i must to install for that
    You can use HS(Heterogeneous Services) .
    http://docs.oracle.com/cd/E11882_01/server.112/e11050/tgvsgc.htm#HETER002

    Aman....
  • 2. Re: connect oracle64bit (linux) to access
    narges Newbie
    Currently Being Moderated
    my database is on linux64bit and it hasn't ODBC Driver.
    what i must to do?
  • 3. Re: connect oracle64bit (linux) to access
    EdStevens Guru
    Currently Being Moderated
    user498843 wrote:
    dose it possible to connect oracle 64bit(linux) to access?
    what i must to install for that
    Do you want Oracle to read from the Access "database"?
    Or do you want Access to read from the Oracle database?

    If the former, I haven't a clue and would ask what the real business problem is.

    If the latter, Access will - by definition -- be running from Windows. You'd need to install the oracle client with windows components, and configure ODBC.

    Edited by: EdStevens on Sep 22, 2012 8:14 AM
  • 4. Re: connect oracle64bit (linux) to access
    Paul M. Oracle ACE
    Currently Being Moderated
    dose it possible to connect oracle 64bit(linux) to access?
    See http://www.orafaq.com/node/60
  • 5. Re: connect oracle64bit (linux) to access
    narges Newbie
    Currently Being Moderated
    My Linux is OEL 5.4 and i installed unixODBC by oracle validate.
    But i don't know how to config that.
  • 6. Re: connect oracle64bit (linux) to access
    Paul M. Oracle ACE
    Currently Being Moderated
    My Linux is OEL 5.4 and i installed unixODBC by oracle validate.
    Did you read the link I posted ? You don't need ODBC on linux, but only on Windows machine.
  • 7. Re: connect oracle64bit (linux) to access
    narges Newbie
    Currently Being Moderated
    I want to connect Oracle to access and get some data from access to oracle.
    my servers has the following spec:
    oracle server(destin):
    1- OS=Oracle Enterprise Linux 5.4 -64bit
    2- Database= Oracle 1.0.0.4 64bit
    3- unixODBC which is installed by oracle validate
    source
    1- OS =Windows 32bit
    2- Database= Access

    I find a document in address http://www.dbapool.com/articles/06280701.html
    But
    how could i config unixODBC which is installed by oracle validate?where is config file?
  • 8. Re: connect oracle64bit (linux) to access
    kgronau Guru
    Currently Being Moderated
    When you want to link MS Access and an Oracle database you first need to think about the driving site. You can link an Oracle table into MS Access which would require to have an Oracle ODBC driver installed, but you can also link a MS Access table into the Oracle database which would require the Database Gateway for ODBC (also called Heterogeneous Services for ODBC in releases prior Oracle 11) and a suitable 3rd party ODBC driver which can connect to the MS Access database.


    According to the header you want to connect from your Oracle database to MS Access. So you need to use the Database Gateway for ODBC. DG4ODBC is available for several Unix platforms and also for MS Windows. When you use DG4ODBC on Unix you commonly need an ODBC Driver Manager (unixODBC) and the real ODBC driver which can connect to the MS Access database. I'm only aware of one ODBC driver on Unix that allows you to handle MS Access mdb files, it is from http://mdbtools.sourceforge.net/. BUT please be aware that this driver is NOT DG4ODBC compliant as it misses some required ODBC functions. For example the version I tested didn't return the correct result for the ODBC function SQLNumResultCols which is mandatory for DG4ODBC. So from this point of view using DG4ODBC on Unix can't be used (with this ODBC driver).

    The better approach that will work is to set up DG4OBC on Windows and to use the MS Access ODBC driver. This ODBC driver will at least allow you to access the MDB file. The connect flow is:
    Your Oracle database on Unix connects to the DG4ODBC installation on Windows which will then load the MS Access ODBC driver and this ODBC driver will then connect to the MDB file of your choice.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points