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,
Neil
Install 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 SQL
>Server running in AD.
>If anyone has done it, kindly let me know since this is new territory for me.
>Thanks,
>Neil