OraFAQ Forum: Networking and Gateways » How to connect SQL Server to a Oracle Database (linked server)

Home » RDBMS Server » Networking and Gateways » How to connect SQL Server to a Oracle Database (linked server)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to connect SQL Server to a Oracle Database (linked server) [message #179967]

Thu, 29 June 2006 08:09

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 20:59:48 CDT 2025