sql server odbc: creating a link server into oracle -- sql server odbc

creating a link server into oracle

Liam Mac
3/9/2006 8:31:31 AM

sql server odbc:

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,

Re: creating a link server into oracle

Sue Hoegemeier
3/11/2006 10:53:22 AM

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
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.