Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Transparent Gateways

Re: Oracle Transparent Gateways

From: Kenneth C Stahl <BlueSax_at_Unforgettable.com>
Date: Tue, 16 Nov 1999 13:32:44 -0500
Message-ID: <3831A34C.CFC0E1B5@Unforgettable.com>


Connor McDonald wrote:
>
> Kenneth C Stahl wrote:
> >
> > Could someone provide a brief description of what a transparent gateway
> > provides?
> >
> > Is there a transparent gateway that will run on a Unixware platform to
> > access a Sql Server 6.5 database running on an NT server?
>
> The theory is that you just run your normal standard Oracle SQL against
> the remote source (via a dblink) and the gateway "magically" converts
> into the SQL that the other vendor db will understand...
>
> I've used the Oracle => DB2 one before and it does work albeit a little
> slowly...Similarly, sometimes joins across the nodes caused a few
> dramas, but on the whole, it was fine.
>

Can you run procedures which are stored in the remote database? Received on Tue Nov 16 1999 - 12:32:44 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US