Re: alternativ transparent gateway ??

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 4 Feb 2004 06:36:49 -0800
Message-ID: <2687bb95.0402040636.56457787@posting.google.com>

"Jens Mander" <edgarellen_at_tonline.de> wrote in message news:<bvp3bj$gdm$07$1_at_news.t-online.com>...
> Hello
>
> are they any ideas to connect to another dbms like informix without a
> transparent gateway ?
> I have 2 datasources (oracle and informix) and i want to query both to make
> one report with oracle reports from this results.
>
> can anybody help me ?

1- it is possible to write ODBC programs that connect to multiple databases
so you could to this route

2- Look at Oracle's heterogenous services feature available with 8.1.7 up; however this requires that you possess an ODBC driver to the other database for the Oracle database server platform. There are white papers on metalink on setting up this feature

HTH -- Mark D Powell -- Received on Wed Feb 04 2004 - 08:36:49 CST