Re: Linking MS SQL to Oracle 9i

Bill.Yager_at_Dirigo.com (Bill Yager) wrote in message news:<e70fc892.0208291119.727e3217_at_posting.google.com>...
> Hi,
>
> Was wondering what methods exist for accessing MS SQL data from an
> Oracle 9i database. I only need READ ONLY access to the MS SQL DB and
> need a method that doesn't require additional licencing costs (if
> possible), such as capabilities built-in to 9i. I know I can set up a
> DB link to another Oracle DB, can I do the same to MS SQL? My 9i DB
> runs on Solaris 7.

You can create a DB link if you set up Oracle Heterogenous Services. I'm not sure whether that will incur more licensing costs for you.

A search on OTN will give you lots of documents about how to set this up.

Justin Received on Fri Aug 30 2002 - 07:01:31 CEST