Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: database link
to create a database link to a "non-Oracle system", I believe you need the Oracle "Transparent Gateway" for the appropriate database (Informix, Sybase, etc) installed on the non-Oracle system.
<yong321_at_yahoo.com> wrote in message
news:8gss7n$num$1_at_nnrp1.deja.com...
> In article <8gsj7p$ie9$1_at_newton.pacific.net.sg>,
> "Richard Taylor" <richard_tay_at_manulife.com> wrote:
> > now that's easy,
> > CREATE [PUBLIC] DATABASE LINK db_link_name
> > CONNECT TO username IDENTIFIED BY password
> > USING 'connect_string/alias';
> >
> > now, can anyone tell me if a db link is possible with a
third-party
database
> > (on a separate host) connected via ODBC?
> >
> > thanks.
>
> I didn't try this. But SQL Reference for CREATE DATABASE LINK
says "The
> remote database can be either an Oracle or a non-Oracle
system".
>
> --
> Yong Huang
>
> (yong321_at_yahoo.com)
> (http://www.stormloader.com/yonghuang/)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Received on Wed May 31 2000 - 00:00:00 CDT