[Info-vax] Client for MS SQL Server

[APAL]

On Mar 4, 5:49 am, Jeremy Begg <jeremy.removet... at vsm.com.au> wrote:
> Hi Alan,
>
> > 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.  :-)
>
> Three commercial products spring to mind:
>   - Attunity Connect
>   - CONNX
>   - Easysoft
>
> I've heard nothing but good reports for CONNX.  One of my customers ran it
> for many years, until they retired their VAXes.
>
> I believe a lot of people are happy with Attunity, but I have no experience
> with it.
>
> I used Easysoft many years ago and it worked well.  The only problem was
> that setting up multiple directories of identical-layout RMS files was a
> pain; I think we had to define the data format as part of the data source
> definition, which meant creating about 30 copies of the same data formats.
> This was 10 years ago now so they might have improved it since then!
>
> I'm not aware of any open-source or freeware options in this area, but
> that's not to say there aren't any.
>
> Regards,
>
>         Jeremy Begg

You may want to take a look at http://www.connx-net.com/datasync.htm

Regards,

Anthony