Re: Connecting to ferign Database via ODBC

From: Lee <lgyu_at_ibm.net>
Date: Mon, 11 Oct 1999 11:24:16 -0400
Message-ID: <38020120.D20D20A7@ibm.net>

There is a product call Oracle Open Gateway for ...; I haven't found out many details about it except that Oracle charges $11K for it. If you look in the Oracle Documentation about Heterogeneous Distributed Databases, it discusses the technology a little.

I'm trying a different tack: generate an external procedure to call from PL/SQL; the external procedure opens up ODBC on both databases.

private_comm_at_my-deja.com wrote:

> Hi all,
>
> Is it possible to connect to a foreign database (such as SQL Server or
> DB2) and receive data from it by using a database link? If so how
> would you go about it?
>
> PC.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 11 1999 - 10:24:16 CDT