Apr 18 2013

Oracle DbLink With Odbc Connection From Oracle to MsSQL Server With FreeTDS

Category: Administration,Linux & Unix,Procedure,SQLFatih Acar @ 14:08

I will use Oracle 11g R2 database and SQL Server 2008 R2 on this example. If you want to connect from Oracle to SQL Server, you can use freeTDS connection library on Oracle Linux systems. If we use Windows Server for Oracle database, we can use direct Windows ODBC Driver Manager. On the other hand, we need some requirement for odbc connection on Linux System. FreeTDS is a odbc connection library for MsSQL Server and other database systems.

I made test below systems.

Systems

  • Oracle Linux 6.x / 7.x
  • Oracle 11g / 12c
  • Windows Server 2008 R2
  • MsSQL Server 2008 R2

dblink

Steps;

  • Download freetds-stable program
  • Install unixODBC and unixODBC-devel
  • Install freetds
  • Configure freetds.conf
  • Configure odbc.ini
  • Configure init
  • Configure Listener
  • Configure tnsnames
  • Create DbLink

Download freetds-stable

Download Page, Direct Download

Install unixODBC-devel

yum install unixODBC
yum install unixODBC-devel

Install Development Tools

yum groupinstall “Development Tools”

Install freeTDS

tar zfvx freetds-stable.tgz
cd freetds-0.91
./configure –prefix=/usr/local/freetds –with-tdsver=8.0 –enable-msdblib –with-gnu-ld
make
make install

Continue reading “Oracle DbLink With Odbc Connection From Oracle to MsSQL Server With FreeTDS”

116,825 total views, 2 views today

Tags: FreeTDS ODBC Connection, Linux Administration, Oracle, Oracle Administration, System Administration