Accessing Oracle from within SQL Server

Using Oracle's Heterogeneous Services, it's possible to gain access to
SQL Server tables via ODBC.
Is the reverse possible? Does SQL Server have the ability to read/write
from/to an Oracle table using ODBC? Is there anything to install? Or
is this functionality that comes with SQL Server?
Thank you.
Paul AndersonYes it's possible. You need to install and configure the
Oracle client on the SQL Server box.
You can find additional information in SQL Server books
online under topics such as Linked Servers and Distributed
Queries. The following article also has some information on
this:
How to set up and troubleshoot a linked server to an Oracle
database in SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Wed, 28 Jun 2006 08:25:00 -0400, Paul Anderson
<patech1@.magma.ca> wrote:

>Using Oracle's Heterogeneous Services, it's possible to gain access to
>SQL Server tables via ODBC.
>Is the reverse possible? Does SQL Server have the ability to read/write
> from/to an Oracle table using ODBC? Is there anything to install? Or
>is this functionality that comes with SQL Server?
>Thank you.
>Paul Anderson