RE: Oracle heterogeneous services - Experiences anyone?

I had set up the feature on 8.1.7 to allow accessing SQL Server data from Oracle running on AIX. You have to obtain, that is, buy a third party supplied ODBC driver on all platforms except Windows where one is provided. Data Direct was the vendor I tested with. We successfully performed simple select, insert, and updates before the developers decided that wanted to use a Java program. The Data Direct driver did not require an agent to be running on the Windows platform.

Read the metalink documents on setting this up carefully. HTH -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Andreas.Haunschmidt_at_voestalpine.com
Sent: Friday, November 19, 2004 6:05 AM
To: oracle-l_at_freelists.org
Subject: Oracle heterogeneous services - Experiences anyone?

Dear List Members!

A collegue of mine not having access to this list=20 needs to exchange data between an Oracle 9 and a Microsoft SQL-Server = database.=20
As far as I know he needs only to access SQL-Server data from Oracle. He would like to know about the experiences people made using Oracle heterogeneous services for that purpose.

I would be thankful if anyone liked to share his/her experiences, and knowledge about reliability, performance,pitfalls and other = "special"=20
features in a production environment.

Thanks in advance

--

Andreas Haunschmidt
voestalpine Informationstechnologie GmbH / Linz Abt. TWI
VOEST-ALPINE-Str. 3, Postfach 3, 4031 Linz, =D6sterreich Tel.: +43-732-6585-3386
Fax: +43-732-6980-9411
E-Mail: andreas.haunschmidt_at_voestalpine.com http://www.voestalpine.com/informationstechnologie =20
=20
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Fri Nov 19 2004 - 08:36:50 CST