Re: database link

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.