Received: (qmail 25319 invoked from network); 9 Sep 2009 13:07:51 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 9 Sep 2009 13:07:37 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AD59FCAD1A4; Wed, 9 Sep 2009 14:06:27 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at localhost.localdomain Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id H-Qf6A13IF5a; Wed, 9 Sep 2009 14:06:27 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EC342CAC5FD; Wed, 9 Sep 2009 14:05:50 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 09 Sep 2009 14:05:09 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1EC76CAE224 for ; Wed, 9 Sep 2009 14:05:09 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id UCIIXx9Hn+Io for ; Wed, 9 Sep 2009 14:05:09 -0400 (EDT) Received: from mail-yx0-f179.google.com (mail-yx0-f179.google.com [209.85.210.179]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 472A4CAE2C5 for ; Wed, 9 Sep 2009 14:05:03 -0400 (EDT) Received: by yxe9 with SMTP id 9so5887632yxe.26 for ; Wed, 09 Sep 2009 11:04:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=dLyUkrYTMhVVgAgAYD7jsT6HBs03Kc/sj0RQSvKbHD4=; b=S28q/jarcGZnYA5xkPbHqqKRKaSlbqKjWrJ+c/VTdPxeH6flF0nCsOXbSuro6wRe6k JxU+9H2Ryf+oJVNeqBHvpggwOrx6MQ3f4d4BuWnXPKD/ImPvfMR3vedS+xjAMEgfCONp 5c7zAoauaetdiF0u7np7V6B8tphjBLA5UYKbw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=KRnIY6htvI9Stq3WAEIY9Q78fZ3BlfrVBMZe94UmQTA2lWnatYS+DQ3uM/DPnrhdiB r5r9ZeDd4SPaQaLqSXQoohqciCjB8UXnlK+iLG7XkDSIHs/8Z/qkvFk2KUWTNUr86Wih onG9A2SAXyeSZVyfXQhPO8nGkJJFKIftXK4Js= MIME-Version: 1.0 Received: by 10.101.56.13 with SMTP id i13mr497507ank.194.1252519496513; Wed, 09 Sep 2009 11:04:56 -0700 (PDT) In-Reply-To: <6B0D50B70F12BD41B5A67F14F5AA887F58BCA2@us-bos-mx022.na.pxl.int> References: <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027@MSXMBCCR2.roswellpark.org> <6B0D50B70F12BD41B5A67F14F5AA887F58BCA2@us-bos-mx022.na.pxl.int> Date: Wed, 9 Sep 2009 14:04:56 -0400 Message-ID: <8311a5b60909091104v4717f68cvc313bd88f68950bd@mail.gmail.com> Subject: Re: Oracle to SQL Server From: chet justice To: Richard.Goulet@parexel.com Cc: Brian.Zelli@roswellpark.org, Oracle L Content-Type: multipart/alternative; boundary=001636ed738ba9faac047328eb57 X-archive-position: 20682 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: chet.justice@gmail.com Precedence: normal Reply-to: chet.justice@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --001636ed738ba9faac047328eb57 Content-Type: text/plain; charset=ISO-8859-1 I can't speak to Oracle on anything but Windows, but I've used this ( http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358) before to connect to a DB2 instance. On Wed, Sep 9, 2009 at 1:34 PM, Goulet, Richard wrote: > Brian, > > There are two ways to do this, the expensive way(maybe) and the cheap > way(maybe). > > Method 1 would be to acquire a copy of the Transparent Gateway to > SQL*Server from Oracle. It installs on the sql server box and then acts > like a remote database. Very easy, but potentially expensive as we're > talking about software form Oracle, although some bird recently told me that > Oracle is "giving" this software away. If you can believe that!! > > Method 2 is to configure Heterogeneous services, basically ODBC, > between Oracle and Sql*Server. If your running Oracle in Windoze that might > be easy, but if your on Unix, well lots of luck as I have not managed to get > it working yet (which is where the expense is, namely your time chasing it). > > > *Dick Goulet*** > Senior Oracle DBA/NA Team Lead > PAREXEL International > > > ------------------------------ > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Zelli, Brian > *Sent:* Wednesday, September 09, 2009 1:12 PM > *To:* Oracle L > *Subject:* Oracle to SQL Server > > Hello all, > A manager just asked me to make a connection from oracle to sql server > and wants a view created from sql server data. I've gone the other way but > never from oracle to sql server. I did a quick google and some things > didn't seem clear. Can anybody point me in the right direction? > > > > ciao, > > Brian > > > > > This email message may contain legally privileged and/or confidential > information. If you are not the intended recipient(s), or the employee or > agent responsible for the delivery of this message to the intended > recipient(s), you are hereby notified that any disclosure, copying, > distribution, or use of this email message is prohibited. If you have > received this message in error, please notify the sender immediately by > e-mail and delete this email message from your computer. Thank you. > -- chet justice www.oraclenerd.com --001636ed738ba9faac047328eb57 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I can't speak to Oracle on anything but Windows, but I've used this= (http://asktom.oracle.com/pls/asktom/f= ?p=3D100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358) before t= o connect to a DB2 instance.

On Wed, Sep 9, 2009 at 1:34 PM, Goulet, Rich= ard <Ric= hard.Goulet@parexel.com> wrote:
Brian,
=A0
=A0=A0=A0 There are two ways to do this, the expensive=20 way(maybe) and the cheap way(maybe).
=A0
=A0=A0=A0 Method 1 would be to acquire a copy of the=20 Transparent Gateway to SQL*Server from Oracle.=A0 It installs on the sql=20 server box and then acts like a remote database.=A0 Very easy, but=20 potentially expensive as we're talking about software form Oracle, alth= ough some=20 bird recently told me that Oracle is "giving" this software away.= =A0 If you=20 can believe that!!
=A0
=A0=A0=A0 Method=A02 is to configure Heterogeneous=20 services, basically ODBC, between Oracle and Sql*Server.=A0 If your running= =20 Oracle in Windoze that might be easy, but if your on Unix, well lots of luc= k as=20 I have not managed to get it working yet (which is where the expense is, na= mely=20 your time chasing it).
=A0

Dick=20 Goulet
Senior Oracle=20 DBA/NA Team Lead
PAREXEL International

=A0

From: oracle-l-bounce@freelists.org=20 [mailto:= oracle-l-bounce@freelists.org] On Behalf Of Zelli,=20 Brian
Sent: Wednesday, September 09, 2009 1:12 PM
To: O= racle=20 L
Subject: Oracle to SQL Server

Hello=20 all,
=A0=A0 A=20 manager just asked me to make a connection from oracle to sql server and wa= nts a=20 view created from sql server data.=A0 I've gone the other way but never= from=20 oracle to sql server.=A0 I did a quick google and some things didn't se= em=20 clear.=A0 Can anybody point me in the right direction?=A0=20
=A0
=A0

ciao= ,

Brian

=A0

=A0

This email message may contain legally privileged and/or= =20 confidential information. If you are not the intended recipient(s), or the= =20 employee or agent responsible for the delivery of this message to the inten= ded=20 recipient(s), you are hereby notified that any disclosure, copying,=20 distribution, or use of this email message is prohibited. If you have recei= ved=20 this message in error, please notify the sender immediately by e-mail and d= elete=20 this email message from your computer. Thank you.



--
chet justice
www.oraclenerd.com

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