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:lerobe_at_acxiom.co.uk]
> 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:lerobe_at_acxiom.co.uk]
> > 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: 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: Robertson Lee - lerobe
> > INET: lerobe_at_acxiom.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: Gogala, Mladen
> INET: MGogala_at_oxhp.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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Robertson Lee - lerobe
> INET: lerobe_at_acxiom.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: Gogala, Mladen
INET: MGogala_at_oxhp.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).
Received on Wed Jul 31 2002 - 14:17:04 CDT
