Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DB Links
On Feb 9, 4:21 am, "sybrandb" <sybra..._at_gmail.com> wrote:
> On Feb 9, 6:55 am, rumkibhad..._at_gmail.com wrote:
>
> > Can DB Links be used to connect to different oracle and non oracle
> > databases at the same time? For example, Oracle 8.1.2, Sybase 11, SQL
> > Server 2000, SQL Server 6.5 ?
>
> > Regards,
> > Rumki
>
> You would need to configure Heterogeneous Services for that.
> The foreign database will get a properly configured entry in
> tnsnames.ora, this can be used in the database link definition
>
> --
> Sybrand Bakker
> Senior Oracle DBA
As Sybrand said or purchase the Oracle Gateway product since HW options are going to be dependend on your optaining ODBC drivers for your database server platform designed specifically for each remote database product you wish to reach. Depending on your hardware platorm and the target platforms you may or may not be able to find appropriate drivers easily and might have to purchase different drivers from different vendors.
HTH -- Mark D Powell -- Received on Fri Feb 09 2007 - 16:26:29 CST