Re: Oracle to SQL Server
- From: chet justice <chet.justice@xxxxxxxxx>
- To: Richard.Goulet@xxxxxxxxxxx
- 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@xxxxxxxxxxx>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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *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
Other related posts:
