From oracle-l-bounce@freelists.org Fri Nov 19 08:36:50 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAJEaod21638 for ; Fri, 19 Nov 2004 08:36:50 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iAJEaoi21633 for ; Fri, 19 Nov 2004 08:36:50 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D9A9172EACF; Fri, 19 Nov 2004 09:43:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05939-69; Fri, 19 Nov 2004 09:43:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8E1A72DEC7; Fri, 19 Nov 2004 09:34:05 -0500 (EST) Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410511E680@usahm236.amer.corp.eds.com> From: "Powell, Mark D" To: oracle-l@freelists.org Subject: RE: Oracle heterogeneous services - Experiences anyone? Date: Fri, 19 Nov 2004 09:24:11 -0500 MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 12439 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark.powell@eds.com Precedence: normal Reply-To: mark.powell@eds.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Andreas.Haunschmidt@voestalpine.com Sent: Friday, November 19, 2004 6:05 AM To: oracle-l@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@voestalpine.com http://www.voestalpine.com/informationstechnologie =20 =20 -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l