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
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
Received on Tue Dec 02 2003 - 15:49:19 CST