RE: Connecting from VAX/VMS to Remote Oracle Data Base

From: Robert Jenkins <rojenkin_at_vansd.org>
Date: Thu, 15 Mar 2001 14:19:49 -0800
Message-ID: <F001.002CDA62.20010315070142@fatcity.com>

It's a new version in beta

>>> Jacques.Kilchoer_at_quest.com 3/14/01 3:40:56 PM >>>

> -----Original Message-----
> From: Robert Jenkins [mailto:rojenkin_at_vansd.org]
> Sent: mercredi, 14. mars 2001 15:05
>
> We have a VAX/VMS7.1 maching with RMS Indexed files that we
> have been trying to connect to.
> I haven't been able to find any ODBC tool to connect to the VAX.
> What I have so far is a company called CONNX has a product
> that will connect to VAX using CONNX and from there you can
> use ODBC to get to Oracle.
> The alternative that we are currently using here is the old
> fashioned method of
> First create a fixed length ascii file on the VAX system.
> Then FTP that to our Oracle server. Then use SQLoader into Oracle.
> Oracle has a 'Transparent Gateway for RMS' that is in beta
> testing. We are going to be participating in that beta.
> Hopefully that will be a better way.

beta testing? I remember at my previous company querying RMS files from inside an Oracle 7.1 database about four years ago, using the Transparent Gateway. You were only allowed "select" (no delete/insert/update) but we were successful in implementing the gateway. At the time there was no mention that the product was in a beta stage. Of course, it might be in "beta" for a new version of Oracle and/or RMS.

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.  

Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Robert Jenkins
  INET: rojenkin_at_vansd.org

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 Thu Mar 15 2001 - 16:19:49 CST