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@xxxxxxxxx>
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
