Re: Creating DB link with SQL Server
From: IM <ian_at_ianmurphy.freeserve.co.uk>
Date: Wed, 15 Apr 2009 03:09:13 -0700 (PDT)
Message-ID: <99b17374-1500-4817-a37c-00d77d97d428_at_q16g2000yqg.googlegroups.com>
On Apr 15, 9:11 am, yossarian <yossaria..._at_operamail.com> wrote:
> Mladen Gogala wrote:
> >> Just to add to it, the oracle DB is installed on a linux platform
>
> > And on which platform is SQL Server installed? Just kidding, we all know
> > that there can be only one, as in Highlander. You can buy a transparent
> > gateway for SQL Server and Oracle will allow you to create a DB link
> > pointing to SQL Server
>
> You may also want to try a free solution using Oracle Heterogeneous
> Services, UnixODBC and FreeTDS (http://www.freetds.org/) and see if it
> fit your needs.
>
> Y.
Date: Wed, 15 Apr 2009 03:09:13 -0700 (PDT)
Message-ID: <99b17374-1500-4817-a37c-00d77d97d428_at_q16g2000yqg.googlegroups.com>
On Apr 15, 9:11 am, yossarian <yossaria..._at_operamail.com> wrote:
> Mladen Gogala wrote:
> >> Just to add to it, the oracle DB is installed on a linux platform
>
> > And on which platform is SQL Server installed? Just kidding, we all know
> > that there can be only one, as in Highlander. You can buy a transparent
> > gateway for SQL Server and Oracle will allow you to create a DB link
> > pointing to SQL Server
>
> You may also want to try a free solution using Oracle Heterogeneous
> Services, UnixODBC and FreeTDS (http://www.freetds.org/) and see if it
> fit your needs.
>
> Y.
You can also go from SQL Server to Oracle with "Linked Servers" in SQL Server. May not be what you are after but it's there for you anyway.
Cheers,
IM Received on Wed Apr 15 2009 - 05:09:13 CDT