Re: Oracle to SQL Server
Date: Thu, 10 Sep 2009 03:17:23 +0800
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
> 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-lReceived on Wed Sep 09 2009 - 14:17:23 CDT