Re: Creating DB link with SQL Server
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 15 Apr 2009 08:11:12 -0500
Message-ID: <10lFl.29119$ZP4.17425_at_nlpi067.nbdc.sbc.com>
IM wrote:
> On Apr 15, 9:11 am, yossarian <yossaria..._at_operamail.com> wrote:
>
> 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
Date: Wed, 15 Apr 2009 08:11:12 -0500
Message-ID: <10lFl.29119$ZP4.17425_at_nlpi067.nbdc.sbc.com>
IM wrote:
> 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
I always found it much easier to go from SS->Oracle Received on Wed Apr 15 2009 - 08:11:12 CDT