HP OpenVMS Systems

ask the wizard

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
SYS$SPECIFIC:[SYSMGR]SQLHOSTS.DAT. Is this required?
 
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.
 
Thanks
sundar

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