Home » RDBMS Server » Networking and Gateways » How to connect SQL Server to a Oracle Database (linked server)
icon4.gif  How to connect SQL Server to a Oracle Database (linked server) [message #179967] Thu, 29 June 2006 08:09 Go to next message
san1901
Messages: 2
Registered: June 2006
Junior Member
I have a Windows 2003 running SQL Server 2000. I want to create a linked server to access an Oracle database instance but I need to create a SQL*Net alias name on the server running SQL Server that points to the Oracle database and I do not know how to do it or what utility to use. I never used Oracle and this is the first time I need to work with it.
Can anybody help me with this task?
Thank you very much.

Report message to a moderator

Re: How to connect SQL Server to a Oracle Database (linked server) [message #181876 is a reply to message #179967] Wed, 12 July 2006 01:20 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
I use a database link on an Oracle database to look into other databases. If it would help I can send you code to create an Oracle database link.

Report message to a moderator

Re: How to connect SQL Server to a Oracle Database (linked server) [message #182157 is a reply to message #181876] Thu, 13 July 2006 06:06 Go to previous message
san1901
Messages: 2
Registered: June 2006
Junior Member
Thank you for answer to my question.
Yes please send me the steps to link the databases.
Thank you.

Report message to a moderator

Previous Topic: Db link gives "Could not resolve service name" error
Next Topic: Networkimg Error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 19:12:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.