Oracle-L: RE: DB Link to MS SQL Server ?

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 19 Jun 2002 15:34:23 -0800
Message-ID: <F001.004821BD.20020619153423@fatcity.com>

Or if on Oracle 816 or above and you have a SQL Server ODBC driver for your platform then you can use Oracle's free Heterogeneous Services.

There are some limitations though compared to the Gateway.

On Metalink take a look at
note 114820.1 helpful - "QUICK START GUIDE: WIN NT - Generic Connectivity using ODBC" Also note 109730.1 - How to setup generic connectivity (Heterogeneous Services) for Windows NT

Also search for Heterogeneous Services in doco and Technet. eg - Take a look at http://technet.oracle.com/products/gateways

HTH,
Bruce Reardon

-----Original Message-----
Sent: Thursday, 20 June 2002 8:30

You need Oracle Gate way for this connectivity.

-----Original Message-----
Sent: Wednesday, June 19, 2002 2:54 PM

Gurus,

Is there a way to connect from Oracle Database to MS SQL Server or vise versa ?

Please share your information.

Thanka

Author: Bob Robert
INET: mssql_2002_at_yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jun 19 2002 - 18:34:23 CDT