Hi Folks,

Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
have successfull DTS application which takes info from the Orcale database
into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
created a linked server into Orcale, have succesfull created link servers
between MS SQL servers but NOT between MS SQL and orcale. I have checked the
web but finding it hard to come across good instructions. I would appreciate
if anyone can point me to a good web sites or instructions. Can I use my
third party driver(DSN) in creating a linked server?

thanks,
liamo

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 Thu, 9 Mar 2006 08:31:31 -0800, Liam Mac
<LiamMac@discussions.microsoft.com> wrote:

>Hi Folks,
>
>Pretty new to linked servers, however I need to create a linked server from
>MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
>have successfull DTS application which takes info from the Orcale database
>into MS SQL, using third party Oracle driver via DSN entry. I'm now need to
>created a linked server into Orcale, have succesfull created link servers
>between MS SQL servers but NOT between MS SQL and orcale. I have checked the
>web but finding it hard to come across good instructions. I would appreciate
>if anyone can point me to a good web sites or instructions. Can I use my
>third party driver(DSN) in creating a linked server?
>
>thanks,
>liamo