Re: DBLink from Oracle to SQL Server

It sounds like it's a lot easier to setup the other way around.

On 29 September 2017 at 06:03, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> There is Oracle heterogeneous gateway which can use any ODBC driver. If
> you are on Linux, the ODBC driver is FreeTDS. Oracle ODBC gateway is free,
> but does not support distributed transactions. You can query or update, but
> only a single database at a time. Here is documentation:
>
> https://docs.oracle.com/database/121/ODBCU/intro.htm#ODBCU100
>
>
> Here is some help from always helpful Tim Hall:
>
> https://oracle-base.com/articles/misc/heterogeneous-
> services-generic-connectivity
>
>
> Easysoft, the ODBC driver vendor, also has some instructions:
>
> http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html
>
>
> Finally, MS SQL Server driver for Linux is here:
>
>
> http://www.freetds.org
>
>
> May the force be with you!
>
> Last time I was playing with it, it took me a week to get it right. Use
> the Google, my young padawan, use the Google.
>
>
>
>
>
> On 09/28/2017 04:53 PM, Upendra nerilla wrote:
>
> Hello everyone -
>
> Is there a way to create a dblink from Oracle to SQL Server through any
> free product? I am familiar with Oracle Database Gateway product, which I
> am trying to avoid.
> If anyone have pointers, much appreciated.
>
>
> Thanks in advance
> -Upendra
>
>
> --
> Mladen Gogala
> Oracle DBA
> Tel: (347) 321-1217
>
>

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