RE: Oracle Heterogenous Services

The advantage is that you're not loading data from an ODBC source into the database. You are viewing the source over a DB Link and so see a real time view of it. If you have production data in Excel spreadsheets or Access databases then it can be very convenient to have a current view of that from Oracle.

(This is not an invitation to flame me about the prudence of keeping
production data in Access or Excel. If it were my choice, it wouldn't be there).

Beth

-----Original Message-----
Sent: Wednesday, July 31, 2002 10:14 AM
To: Multiple recipients of list ORACLE-L

And is it needed?. I am sure I have set up odbc connections between Oracle
8i databases on Unix and Access/Excel and I have never heard of Heterogeneous Services before

-----Original Message-----
Sent: 31 July 2002 13:24
To: Multiple recipients of list ORACLE-L

I did a bit of research on Heterogeneous Services, apparently it lets you
create ODBC connections between Oracle on UNIX and Windows apps.  

Can this be true?  

Does it actually work?  

What is the performance like?  

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

.

-----Original Message-----
Sent: Wednesday, July 31, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L

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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: John.Hallas_at_vodafone.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Seefelt, Beth
  INET: Beth.Seefelt_at_TetleyUSA.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).