How to connect SQL Server to an Oracle database

I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me
.
Thanks,
NeilInstall the Oracle client on the SQL Server box.
Configure the client side (SQL Server box) tnsnames, Oracle
alias as needed for your Oracle environment.
Configure a linked server, following the books online topic:
OLE DB Provider for Oracle
as well as the following article:
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in
SQL Server
http://support.microsoft.com/?id=280106
-Sue
On Fri, 13 Jan 2006 09:31:39 -0800, N.Ordiers
<NOrdiers@.discussions.microsoft.com> wrote:

>I need to connect to an Oracle database (8i) running in a UNIX box, with SQ
L
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for m
e.
>Thanks,
>Neil