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

[EMAIL PROTECTED] (Andrea M. Segovia) wrote in message news:<[EMAIL PROTECTED]>...
> 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