[Info-vax] Client for MS SQL Server

[sapienzaf]

On Mar 3, 3:05 pm, Alan Frisbie <Usenet02_REM... at Flying-Disk.com>
wrote:
> I would like to do the opposite: use my VMS system to act
> as an ODBC server to the Windoze systems.   What have people
> used, and what do you recommend?
>
> All our data is in RMS indexed files.   Files range from
> 100,000 40KB records to one with a few million 32-byte
> records.   A typical lookup would involve merging data
> from a dozen records in three files before returning
> it to the user.
>
> In our case, simple is better.   Inexpensive is better yet.  :-)
>
> Alan Frisbie

a) You could get the Oracle RDB ODBC driver and convert everything to
an RDB database.  Not inexpensive, given the license and software
migration costs, but RDB is probably a better long-term solution.

b) Look into Attunity Connect for OpenVMS.   You will have to create
metadata definitions for all the files to which you need access.  If
you already have CDD definitions then you can use those.

http://h71000.www7.hp.com/partners/attunity/index.html