HP OpenVMS Systems

ask the wizard
Content starts here

Distributed Database Query?

» close window

The Question is:

We have a very large application running on OpenVMS 7.3 COBOL/RMS environment.
 We need to attach to a SQL server7 database on an NT server for extracting
 some data on a daily basis.
One method I know is thru BEA queue send the request and get the reply back. Is
 there any connectivity method available so that my connection could be direct.
I did not find the floowoing file in our set up
Are there any ODBC/JDBC/UDBC like connections exist in VMS. I have done the
 other way from a NT client to Rdb using ODBC/JDBC connections. This is new to
 me. Any help is appreciated.

The Answer is :

  ODBC, JDBC, COM/DCOM, and packages such as BEA MessageQ and
  Iona are the usual approaches for this.  Database vendors
  offering OpenVMS databases may have connectors, as well.

answer written or last revised on ( 1-MAY-2002 )

» close window