Re: Oracle to SQL Server

From: Tanel Poder <tanel_at_poderc.com>
Date: Thu, 10 Sep 2009 03:17:23 +0800
Message-ID: <4602f23c0909091217o41441fcbndf5a6ffbe0e1a3da_at_mail.gmail.com>

On newer linux distros you can just install UnixODBC and FreeTDS (and mysql/postgres ODBC drivers) as packages / rpms so there shouldn't be any hassle getting the drivers to work.

Configuring the data sources may require some doc-reading but it's not complex.

On Thu, Sep 10, 2009 at 2:29 AM, Taylor, Chris David < ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> About 3 years ago (4 now maybe?) I had HSODBC working on Linux to Windows
> SqlServer.
>
> If I remember correctly I used UnixODBC (but not positive). Might have
> used FreeTDS as well but its been a while.
>
> CAVEAT: IF you are using 9i, then you have to use a 10g (or newer)
> listener as the listener controls/interfaces with the HSODBC connectivity -
> the 9i HSODBC is a no-go on RHEL. Once you have the 10g listener, and
> HSODBC setup, the connectivity works but it does take some time to get
> familiar with it and set it up and then tweak it.
>
>
>
>
>

-- 
Tanel Poder
http://blog.tanelpoder.com

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

Received on Wed Sep 09 2009 - 14:17:23 CDT