Oracle Database - Oracle db to sql server management

Hello Expert !

Shall you please give me idea how i connect oracle database in sqlserver management studio and query data from both oracle db and sql server db at once ???


Thanks

You'll want to use sp_addlinkedserver to establish a link:

EXEC sp_addlinkedserver  'MakeUpANameForThisLinkToShowInManagementStudio', 'Oracle',  'MSDAORA', 'your oracle server name'

You may also need to create link for the logins:

EXEC sp_addlinkedsrvlogin 'MakeUpANameForThisLinkToShowInManagementStudio', false, 'SQL User', 'Oracle User',   'Oracle Password'

When you query, you do this:

select * from
  MakeUpANameForThisLinkToShowInManagementStudio...ServerInstanceName.TableName

http://msdn.microsoft.com/en-us/library/ms190479.aspx

Robe,

I have successfully added the linked server by you commands ,but when i trying to test connection i am getting the below error?