Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing data from an MS access db from an Oracle UNIX server
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