How to query an Oracle table from SQL Server 2000?

Question

An employee would like to query a table in an Oracle database using SQL Server 2000, Enterprise Manager.

He knows how to do the whole DTS thing, but doesn’t want to go this route to add hoc requests.

Is there another way?

Answer 1

Here's a step-by-step guide: Configuring a Linked Oracle Server

Note that the default Microsoft driver for Oracle RDBMS does not work, so you need to install the Oracle client (or instant client)

Another Microsoft Link: MSDN

Answer 2

Linked Server ( Security in Enterprise Manager). :

SELECT * FROM OracleServer.Database.dbo.Table

- Oracle , , "dbo" , SQL Server.