Linking To Oracle in SQL Server 2000 1

[ThomMenzies]

I'm new to SQL Server and am not sure whether it is possible to link to an Oracle table using SQL Server. I previously used Microsoft Access through which it is dead easy to link to Oracle. I have found out how to import data via SQL Server, but not linking.

Can anyone help?

Thom

 

[JamesLean]

You can set up a linked server in your SQL Server. Look up "linked servers" in SQL BOL. It is a relatively straight-forward procedure. --James

 

[sguslan]

Here is the link at MSDN with exmples on linking into Access and Oracle, and of course when you finish creating the linked server you can use it with FQN syntax, such as :

select * from from oraclelinkedserver..schemaname.tabname

or

insert into oraclelinkedserver..schemaname.tabname
select * from sqltable



The MSDN link is:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp