creating a link server into oracle

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

creating a link server into oracle

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 alread
y
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,
liamoInstall 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 alrea
dy
>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 th
e
>web but finding it hard to come across good instructions. I would appreciat
e
>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

creating a connection to DB2 from sql server

Can We Create a SQL Server connection to DB2 using linked servers?If yes, how can we do that.ANd one more thing is that my DB2 is on unix and sqlserver is on windows.
Thanks.This MSDN http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_1gvm.asp link will explain the scenario.