Re: Linked Server to Oracle

Serge Rielau wrote:
> Can Oracle 8 act as an OLE DB provider to SQL Server as consumer?
> In this case there is really no difference between using SQL Server as a
> base through OLE DB vs. Oracle through transparent gateway, other than
> that of control.
>
> Just my two cents
> Serge

Difference is that with the Transparent Gateway and Oracle Developer could issue PL/SQL against the SQL Server database rather than Transact SQL. Cuts down on a lot of training and makes it possible to write single SQL statements that simultaneously hit both back-ends.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)