Showing posts with label fron. Show all posts
Showing posts with label fron. Show all posts

Monday, March 19, 2012

Joining of datasets supported in future version?

Rajeev,
Thanks for your reply. What I am after is being able to join a dataset
fron an SQL Server to one from a different data source, say Oracle.
Would I be right in saying that OpenRowset wouldn't help in this
instance?
PaulYou can do this using the linked server functionality in SQL Server 2000
SP3. Details are available on MSDN:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_9ooj.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Taylor" <pjtaylor@.email.com> wrote in message
news:ce5uun$roq@.odbk17.prod.google.com...
> Rajeev,
> Thanks for your reply. What I am after is being able to join a dataset
> fron an SQL Server to one from a different data source, say Oracle.
> Would I be right in saying that OpenRowset wouldn't help in this
> instance?
> Paul
>