[Info-vax] Client for MS SQL Server

[Jan-Erik Söderholm]

sapienzaf wrote:
> 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.

And you could use the "Rdb Gateway for RMS" and not having to
move over all data to the physical Rdb database. To the ODBC
client it looks the same, even if all data are read from the
indexed RMS files...

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