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 -> Re: Accessing data from an MS access db from an Oracle UNIX server

Re: Accessing data from an MS access db from an Oracle UNIX server

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 03 Dec 2003 10:07:36 -0600
Message-ID: <4h2ssv4k3gr9c3943s7g928nnpu5atftdu@4ax.com>


kidehen_at_openlinksw.com (Kingsley Idehen) wrote:

>andrea_at_mun.ca (Andrea M. Segovia) wrote in message news:<7589088f.0311260806.dc42dce_at_posting.google.com>...
>> Hello,
>>
>> I am a newbie to Oracle databases....
>>
>> We have a visualization front-end tool connected to an Oracle back-end
>> database on a Tru64 UNIX server. We also have clients with MS access
>> databases who would like to share their data using this visualization
>> tool but do not want to import their data into the Oracle server
>> back-end.
>>
>> Is there any way we could use the Oracle backend to query the MS
>> Access databases and merge this data with other data in the Oracle
>> back-end for presentation by the visualization tool? Perhaps through
>> ODBC or some other standard?
>>
>> The Oracle back-end is a a Tru64 UNIX server running Oracle 8i.
>>
>> Any input would be appreciated.
>>
>> Andrea Segovia
>> A/Project Manager
>
>
>Andrea,
>
>A belated response, but just in case you don't have a solution, here
>is what will work:
>
>Oracle HS--> Unix based ODBC Driver for Access ----O--- MS ACCESS on
>Windows.
>
>You can obtain a Unix based ODBC Driver for ACCESS from
>http://www.openlinksw.com
>
>These drivers are available on a free 30 day evaluation basis.
>
>Regards,
>Kingsley Idehen
>OpenLink Software

Where on the site is it hidden? The Only Access drivers I see are for Windows.. Received on Wed Dec 03 2003 - 10:07:36 CST

Original text of this message

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