UNIX Oracle access from VMS

[rsnyderbankofny.com]

I have a new need which will involve accessing an Oracle 9.0.2.3 database running on unix/Solaris from VMS 7.2.3. The VMS applciaiton will also be using Oracle/RDB on the VMS box.

[Hein van den Heuvel · Accepted solution]

I think nothing special needs to be done.
Just install an Oracle client (preferably 9i) and connect through SQL*net.
You can use SQLplus, or your own (OCI?) program.

As always, you will need an entry in TNSnames to translate the db target (XXX) from the connect string (user/pass@XXX) to a node and port on the Unix box.

RDB also has SQL*net support which you can possibly use to make is more transparent.

hth,
Hein.