|
|
Posted by DickChristoph on 03/24/06 21:01
Hi Mark
Check into OpenRowSet. I haven't done it with Oracle but I have with AS/400
DB2 files.
I could run a SQL Select Statement on the DB2 file and then insert the data
into a SQL Server table in a SQL Stored Proc.
--
-Dick Christoph
"Mark D Powell" <Mark.Powell@eds.com> wrote in message
news:1143219908.508356.128400@g10g2000cwb.googlegroups.com...
> We are running SQL Server 2000 SP3. We have linked servers in use that
> we use to access Oracle tables.
>
> Recently the claim has been made that you can access Oracle tables from
> within SQL Server without using a Linked Server. I searched Books
> Online using keywords: linked, remote, and Oracle and did not find
> anything.
>
> A search of the newsgroup archives found only entries related to using
> Linked Servers.
>
> Is there any such method as claimed? I do not think there is, but I
> need to find some support for my position or else learn something new.
>
> Thank you
> -- Mark D Powell --
>
Navigation:
[Reply to this message]
|