Re: Viewing SQL Server through Oracle

I have been told that this is possible if the SqlServer has certain tables install ( to mimic the Oracle Data Dictionary ) - I am not at my home machine to check, but I think there is an Oracle note on this issue - check out Oracle's home page and search for SqlServer.( it may be part of the Oracle Power Objects docs )

Hope it helps,
John Greco
Oracle DBA

Mike Rowland <102622.2522_at_CompuServe.COM> wrote:

>Is there a simple way to access MS SQL Server tables as though
>they are Oracle tables. Some developers would like to use
>something like DBMS links in Access to access these remote tables
>through Oracle.
>
 

>I'm guessing that there should be a way with the base Oracle
>Server that could access them via ODBC, but I thought there may
>be an Oracle Gateway product that would use the MS SQL Server
>native code.
>
 

>Any help would be greatly appreciated.
>Mike Rowland
>
>--
>*****************************************************************
>* The opinions expressed are solely the opinion of Mike Rowland *
>* and not those of Cap Gemini America. *
>*****************************************************************
Received on Mon Nov 03 1997 - 00:00:00 CST