Re: Acessing SQL Server from Oracle Server

From: Venkat <vreddy_at_ix.netcom.com>
Date: Tue, 5 May 1998 09:47:08 -0400
Message-ID: <6in59l$a2q@dfw-ixnews4.ix.netcom.com>

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!
Received on Tue May 05 1998 - 08:47:08 CDT