Re: Best way to connect MS Access 2007 to Oracle 8 database?

TD wrote:
> I am new to Oracle. I need to connect to a Oracle 8 database to
> extract some data. I have read some of the postings and wonder what
> is the least involved way to connect the two. Is the Oracle OLE
> driver (not OLEDB) good?
> I would prefer not install the Oracle client if I don't have to. All
> I need to do is ,once a day, connect to Oracle, run a passthru query
> and disconnect.
>
> Any thoughts???
> Thanks,
> TD

Install the Oracle client.

Nothing about what you are trying to do is good. Oracle 8 is paleolithic and likely the version of MS Access you are trying to use didn't exist when Oracle 8 did. This is all a remarkably bad idea. What is it you think you are going to do in Access you couldn't do inside the database other than corrupt the data?

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org