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 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). > -- > 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).
