Re: Accessing MS Access tables from Oracle ?

You may be correct. I've not gotten that deep into 9i. But I doubt it is through the Oracle Client as the poster requested.

Still, all-in-all, it is a horrible idea.

Daniel Morgan

Niall Litchfield wrote:

> I agree that it is possibly the worst idea I have seen in a while. However
> Oracle9i ships with a feature called 'Generic Connectivity' (not sure if it
> is there in 8i) which allows connection to any OLEDB or ODBC data source
> (presumably though I've not looked through the extproc interface). This
> would appear to allow what the OP wants.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
> "damorgan" <damorgan_at_exesolutions.com> wrote in message
> news:3C8CD41D.CC708FAE_at_exesolutions.com...
> > I do not believe it can be done. Nor can I imagine why anyone would want
> to.
> > Put the data into Oracle and drop Access. It offers nothing that can not
> be
> > done better and faster and safe in Oracle.
> >
> > Daniel Morgan
> >
> >
> >
> > Rastko wrote:
> >
> > > How should I configure Oracle Client to access the MS Access tables
> using
> > > ODBC?
> > >
> > > I've found instructions for accessing Oracle tables from MS Access,
> > > but I need to create an Oracle database link to mdb file.
> > >
> > > thanks,
> > >
> > > Rastko
> >
Received on Mon Mar 11 2002 - 12:43:46 CST