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

Tim,

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.

Good Luck and please let me know if you find another way to do this.

rj

>>> sawmillert_at_state.mi.us 3/14/01 12:10:26 PM >>>
My client is trying to connect from an RDB database on a VAX/VMS machine to an Oracle database on an HP machine. Can this be done? How?

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Tim Sawmiller
  INET: sawmillert_at_state.mi.us 

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).

--
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).