Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connection possible between SQLServer and Oracle7 ?

Re: Connection possible between SQLServer and Oracle7 ?

From: Richard Slochowsky <rslochow_at_svmdhs.com>
Date: Mon, 20 Jul 1998 14:09:53 -0700
Message-ID: <35b3960c.0@chaos.magibox.net>


You might want to look into the Oracle Transparent Gateway for Microsoft SQL Server

--
Richard Slochowsky
Database Administrator
ServiceMaster Diversified Health Services Bas Haenraets wrote in message
<2465A05A033BD111969500805F4BEF5B0F0CAF_at_SULACO>...
>Hello,
>
>does anyone know if it is possible (and if so: how?) to access
>Oracle-data from Microsoft SQLServer, and Microsoft SQLServer-data from
>Oracle? I am quite familiar with Oracle servers, but not with Microsoft
>SQLServer.
>
>My idea was to access the Oracle-data using ODBC, but I'm not sure if
>SQLServer can deal with ODBC connections to Oracle. I know it can
>replicate to an Oracle database, but that's not what I want - I just
>want to access (query, insert, update etc.) the data.
>
>As for the other way around: I have no idea how to access Microsoft
>SQLServer-data from Oracle.
>
>I am running an Oracle 7.0 database on AIX and an SQLServer 6.5 database
>on WinNT.
>Any ideas?
>
>Bas
>
Received on Mon Jul 20 1998 - 16:09:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US