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