Xref: alice comp.databases.oracle.server:20272
Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!ix.netcom.com!news
From: "Venkat" <vreddy@ix.netcom.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Acessing SQL Server from Oracle Server
Date: Tue, 5 May 1998 09:47:08 -0400
Organization: Netcom
Lines: 16
Message-ID: <6in59l$a2q@dfw-ixnews4.ix.netcom.com>
References: <6ilgoo$ud8$1@pema.scs.unr.edu>
X-NETCOM-Date: Tue May 05  8:47:33 AM CDT 1998
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3

I have used Oracle Transparent Gateway for MS SQL Server to achieve this.
You basically create a service name that points to SQL Server and then you
can use that connect string like you would any other connect string.  But
let me warn you that the gateway is exorbitantly priced!!!.  I think you can
download a trial version from Oracle's web site.

regards
Venkat

>I need to allow an Oracle database on an OpenVMS server to update tables
>in a Microsoft SQL Server database.  I would like to handle this using
>PL/SQL stored procedures if possible.  Anyone have any ideas as to the
>best method to handle this?  Any help is appreciated!