RE: Oracle Heterogenous Services

[Lord, David - CSG]

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:24
To: Multiple recipients of list ORACLE-L
Subject: 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 AM
To: Multiple recipients of list ORACLE-L
Subject: 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 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 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.
**********************************************************************