| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connecting from VAX/VMS to Remote Oracle Data Base
> -----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.
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
Received on Wed Mar 14 2001 - 18:20:09 CST
 |
 |