8 Replies Latest reply: Sep 24, 2012 12:47 AM by Kgronau-Oracle RSS

    connect oracle64bit (linux) to access

    narges
      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....
          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
            my database is on linux64bit and it hasn't ODBC Driver.
            what i must to do?
            • 3. Re: connect oracle64bit (linux) to access
              EdStevens
              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.
                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
                  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.
                    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
                      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-Oracle
                        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.