MIME-Version: 1.0
In-Reply-To: <C5533BD628A9524496D63801704AE56D368098A1A2@SPOBMEXC14.adprod.directory>
References: <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F9027@MSXMBCCR2.roswellpark.org>	 <dede63360909091018s45e6fff0w7aa91031bf2d0ac0@mail.gmail.com>	 <6B3493ABEE194842A8EFC3FC3B23DE6A107C8F902E@MSXMBCCR2.roswellpark.org>	 <4814386347E41145AAE79139EAA398980C71FCDA4F@ws03-exch07.iconos.be>	 <C5533BD628A9524496D63801704AE56D368098A1A2@SPOBMEXC14.adprod.directory>
Date: Thu, 10 Sep 2009 03:17:23 +0800
Message-ID: <4602f23c0909091217o41441fcbndf5a6ffbe0e1a3da@mail.gmail.com>
Subject: Re: Oracle to SQL Server
From: Tanel Poder <tanel@poderc.com>
To: ChrisDavid.Taylor@ingrambarge.com
Cc: "Brian.Zelli@RoswellPark.org" <Brian.Zelli@roswellpark.org>, Oracle L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=00504502bc34c3458f047329ee8b
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: tanel@poderc.com
--00504502bc34c3458f047329ee8b
Content-Type: text/plain; charset=ISO-8859-1

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

--00504502bc34c3458f047329ee8b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On newer linux distros you can just install UnixODBC and FreeTDS (and mysql=
/postgres ODBC drivers) as packages / rpms so there shouldn&#39;t be any ha=
ssle getting the drivers to work. <br><br>Configuring the data sources may =
require some doc-reading but it&#39;s not complex.<br>
<br><br><div class=3D"gmail_quote">On Thu, Sep 10, 2009 at 2:29 AM, Taylor,=
 Chris David <span dir=3D"ltr">&lt;<a href=3D"mailto:ChrisDavid.Taylor@ingr=
ambarge.com">ChrisDavid.Taylor@ingrambarge.com</a>&gt;</span> wrote:<br><bl=
ockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, 204=
, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
About 3 years ago (4 now maybe?) I had HSODBC working on Linux to Windows S=
qlServer.<br>
<br>
If I remember correctly I used UnixODBC (but not positive). =A0Might have u=
sed FreeTDS as well but its been a while.<br>
<br>
CAVEAT: =A0IF you are using 9i, then you have to use a 10g (or newer) liste=
ner as the listener controls/interfaces with the HSODBC connectivity - the =
9i HSODBC is a no-go on RHEL. =A0Once you have the 10g listener, and HSODBC=
 setup, the connectivity works but it does take some time to get familiar w=
ith it and set it up and then tweak it.<br>

<br>
<br>
<br>
<br clear=3D"all"></blockquote></div><br>-- <br>Tanel Poder<br><a href=3D"h=
ttp://blog.tanelpoder.com">http://blog.tanelpoder.com</a><br><br>

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