RE: Oracle to Access

[Seefelt, Beth]

Title: Message

 

Hi Lee,

 

 Here is what I did to get it working on NT for an excel spreadsheet.

 

1. Create the ODBC DSN to the data source

2. Make sure heterogeneous services is installed in %ORACLE_HOME%\HS\ADMIN

3. Add the entry in tnsnames.ora with (HS=OK)

4. Add an entry in listener.ora with (PROGRAM=hsodbc)

5. Create the database link to the spreadsheet.

 

If you want some specific examples of the tnsnames and listener entries let me know and I'll dig them up.

 

HTH,

 

Beth

 

 -----Original Message-----
From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 5:48 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle to Access

Hi,

 

Oracle 8.1.7.3

Tru64 5.1

MSAccess 2000

 

Preparing to be shot down in flames but I have been looking through some documentation and also some White Papers but for some reason I just don't get it.

 

I need to see Access tables from an Oracle DB. The paper I am reading (from Metalink) states that I should be able to do this via Heterogeneous Services and ODBC agent but I cannot see how it all hangs together.

 

Has anyone done this and if so could you point me in the right direction please. I don't need an idiots guide (or maybe I do) but a gentle nudge in the right direction should suffice.

 

Regards

 

Lee

 



********************************************************************

The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.