RE: Oracle Heterogenous Services
Yes its true, I've got it working to a sqlserver d/b.The performance I can't vouch for. IIRC you have to install ODBC drivers (not so easy on solaris, Merant do one, but its not free),do some mucking about with the listener and then create a database link to the ODBC d/b. Regards David Lord -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]Sent: 31 July 2002 13:24To: Multiple recipients of list ORACLE-LSubject: Oracle Heterogenous Services 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-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 6:48 AMTo: Multiple recipients of list ORACLE-LSubject: 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 isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged.If the reader of this message is not the intendedrecipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictlyprohibited.If you have received this communication in error,please re-send this communication to the sender anddelete the original message or any copy of it from yourcomputer system. Thank You. ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. **
RE: Oracle Heterogenous Services
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).
RE: Oracle Heterogenous Services
John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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: Robertson Lee - lerobe 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).
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: [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).
RE: Oracle Heterogenous Services
If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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: Robertson Lee - lerobe 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: Gogala, Mladen 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).
RE: Oracle Heterogenous Services
Mladen, I have been told that I definitely need the odbc driver installed on my UNIX server. How do I get these from OTN, they have the odbc software for Windows but not for UNIX. (Not that I can see anyway !!) Lee -Original Message- Sent: 31 July 2002 17:29 To: Multiple recipients of list ORACLE-L If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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: Robertson Lee - lerobe 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: Gogala, Mladen 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
RE: Oracle Heterogenous Services
Lee, are you trying to use your Unix machine as an ODBC client or as a database server server? If it is supposed to be a database server, things are easy and trivial. If your unix box is supposed to be a client, you can find an some ODBC drivers at http://www.unixodbc.org/ . I've never tried using Unix as an ODBC client. -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services Mladen, I have been told that I definitely need the odbc driver installed on my UNIX server. How do I get these from OTN, they have the odbc software for Windows but not for UNIX. (Not that I can see anyway !!) Lee -Original Message- Sent: 31 July 2002 17:29 To: Multiple recipients of list ORACLE-L If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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: Robertson Lee - lerobe 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
RE: Oracle Heterogenous Services
I think I am jumping into this thread a bit late. Take a look at http://www.unixodbc.com for some good info on ODBC on Unix. I am not sure where to get Oracle ODC drivers for Unix. Try installing a Unix client and see if it comes along with it... Babu Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com on 07/31/2002 11:53:36 AM Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Mladen, I have been told that I definitely need the odbc driver installed on my UNIX server. How do I get these from OTN, they have the odbc software for Windows but not for UNIX. (Not that I can see anyway !!) Lee -Original Message- Sent: 31 July 2002 17:29 To: Multiple recipients of list ORACLE-L If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Heterogenous Services John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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: Robertson Lee - lerobe 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego
RE: Oracle Heterogenous Services
And for technical info on setup of Heterogeneous services try the following: I found note 114820.1 helpful - QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT Also note-107227.1 setup and troubleshoot gencon on UNIX And have a look at http://technet.oracle.com/products/gateways Regards, Bruce Reardon -Original Message- Sent: Thursday, 1 August 2002 9:49 I think I am jumping into this thread a bit late. Take a look at http://www.unixodbc.com for some good info on ODBC on Unix. I am not sure where to get Oracle ODC drivers for Unix. Try installing a Unix client and see if it comes along with it... Babu Robertson Lee - lerobe [EMAIL PROTECTED]@fatcity.com on 07/31/2002 11:53:36 AM Mladen, I have been told that I definitely need the odbc driver installed on my UNIX server. How do I get these from OTN, they have the odbc software for Windows but not for UNIX. (Not that I can see anyway !!) Lee -Original Message- Sent: 31 July 2002 17:29 If it's just a regular ODBC connection, download the driver from OTN, configure it appropriately and enjoy. No heterogeneous services needed. Heterogeneous services are needed only if you have more then one protocol on your network (like LU 6.2, TCP/IP and IPX). -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 11:13 AM John, I have done this from PC to Oracle Database on a UNIX server but not the other way around. I think it is different and that is what I am trying to get to the bottom of Lee -Original Message- Sent: 31 July 2002 15:14 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).