Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Accessing MS Access tables from Oracle ?
You are quite right my suggestion is obviously a server side thing. It is
still horrible.
I'm left wondering why given you have a client device you wouldn't just write a prog with connections to the mdb and the server db and have done with it though? surely one doesn't want to interrogate access thru sql*plus.
-- Niall Litchfield Oracle DBA Audit Commission UK "damorgan" <damorgan_at_exesolutions.com> wrote in message news:3C8CFAE0.4C665478_at_exesolutions.com...Received on Mon Mar 11 2002 - 16:00:16 CST
> 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
> > >
>