|
Home > Archive > MS SQL Server ODBC > March 2006 > creating a link server into oracle
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
creating a link server into oracle
|
|
| Liam Mac 2006-03-09, 11:23 am |
| 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
| |
| Sue Hoegemeier 2006-03-11, 1:23 pm |
| 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
|
|
|
|
|