Oracle-L: RE: Oracle Heterogenous Services

From: Lord, David - CSG <David.Lord_at_hayscsg.com>
Date: Wed, 31 Jul 2002 06:43:51 -0800
Message-ID: <F001.004A7505.20020731064351@fatcity.com>

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

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.helpdesk_at_hays.plc.uk
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.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lord, David - CSG
  INET: David.Lord_at_hayscsg.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 - 09:43:51 CDT