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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
