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

TD wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Dec 20, 9:03 am, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
The database account is set to read only and we'll be running select
queries only so I doubt we'll damage the database. We need to extract
data that is in Oracle into a MS Access 2007 program on laptops that
will taken out into the field. I'm not sure how else we can
accomplish that by "doing it inside the database"!

TD

Which is better than the other way around, isn't it? :-)


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Anyone else have any thoughts?

TD

On Thu, 20 Dec 2007, damorgan (AT) psoug (DOT) org wrote:

Why would using MSAccess somehow cause one to corrupt data?

--
Galen Boyer

On Thu, 20 Dec 2007, dlee (AT) adsi-sc (DOT) com wrote:
Don't know the OLE driver, but why can't you install the oracle client?
That really shouldn't be a factor, unless all those on the road are in
need of it as well. Just install it and connect MSAccess through and
ODBC connection. Should work quite nicely.

--
Galen Boyer

On Dec 22, 4:08*pm, Galen Boyer <galen_bo... (AT) yahoo (DOT) com> wrote:
Thannks Galen. Will the 9i client work ok?

On Sat, 22 Dec 2007, dlee (AT) adsi-sc (DOT) com wrote:
Should be. Why not install it and give it a go? You originally posted
on Dec 19th. Its Dec 23rd. You could have easily figured it all out by
now. The install should take a few moments. Connections should take a
few moments. In an hour, you could have figured this out.

--
Galen Boyer

On Dec 23, 9:37*am, Galen Boyer <galen_bo... (AT) yahoo (DOT) com> wrote:
The reason I asked is I have no experience with Oracle so I do not
know if using the wrong client can damage the database. I have many
things on my plate in life so it may be several more days before I can
actually try it.

Will using the wrong Oracle client damage the Oracle database?
TD