Thursday, February 9, 2012

accessing oracle db from sql server 2000

Is there any way to query an oracle database from sql server? Thanks.
Ken,
Yes.Refer 'Linked server' in BooksOnLine and also in the below article:
'HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
(Q280106)'
http://support.microsoft.com/default.aspx?id=280106
Dinesh
SQL Server MVP
--
SQL Server FAQ at
http://www.tkdinesh.com
"ken smith" <anonymous@.discussions.microsoft.com> wrote in message
news:CAA2819F-40D3-44FC-9DD6-1F42BD07CAA5@.microsoft.com...
> Is there any way to query an oracle database from sql server? Thanks.

No comments:

Post a Comment