Re: Oracle Query to MS SQL
From: Geoff Muldoon <geoff.muldoon_at_trap.gmail.com>
Date: Thu, 19 May 2011 09:05:40 +1000
Message-ID: <MPG.283efbcef76c9f9a98968d_at_news.x-privat.org>
Date: Thu, 19 May 2011 09:05:40 +1000
Message-ID: <MPG.283efbcef76c9f9a98968d_at_news.x-privat.org>
art_at_unsu.com says...
>
> On May 17, 5:42 pm, Geoff Muldoon <geoff.muld..._at_trap.gmail.com>
> wrote:
> > a..._at_unsu.com says...
> >
> > > I'm trying to find some information on if it is possible (and how) to
> > > query a MS SQL database from Oracle. We are running 10gR2. I'm
> > > hoping to avoid having to dump tables and load delimited files be
> > > querying the MS SQL database directly.
> >
> > Your solution may be platform-specific. What O/S is Oracle running on?
> We're running on Cent-OS, Oracle 10gR2
You can do it using a listener-based ODBC DBlink connector.
Google: unixodbc freetds oracle
GM Received on Thu May 19 2011 - 01:05:40 CEST