Re: Oracle to SQL Server
Date: Wed, 9 Sep 2009 14:04:56 -0400
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 <Richard.Goulet_at_parexel.com>wrote:
> There are two ways to do this, the expensive way(maybe) and the cheap
> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_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?
> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 09 2009 - 13:04:56 CDT