[Info-vax] Client for MS SQL Server

[Craig A. Berry]

blowhard27 wrote:
> On Feb 28, 1:32 am, Jan-Erik Söderholm <jan-erik.soderh... at telia.com>
> wrote:
>> Michael D. Ober wrote:
>>> Is there an ODBC client for Alpha OpenVMS 8.2?  I need to connect our
>>> database to a MS SQL Server to avoid duplicating data.
>>> Thanks,
>>> Mike Ober.

>>
>> Another way could be to find an client kit for Sybase, which at least
>> worked fine some time ago. Remember that what is today called "MS
>> SQL Server" once was called "Sybase for NT" before MS bought the NT
>> version of Sybase and made it into the current MS product.
>>
>> Jan-Erik.

The old Sybase clients do work with Microsoft SQL Server up through
version 7.0 (though with occasional glitches), but Microsoft has changed
the wire-level protocol with every release so you can't use them with
anything recent.

> You might also try FreeTDS.  I had it working on VMS a  while ago and
> it seemed
> all right.  Search this group's archive for some other people's
> experiences.
> 
> Regards,  Jim

FreeTDS does work (http://www.freetds.org) and gives you a couple of
different API ooptions, ODBC being one of them (in conjunction with the
unixODBC driver manager <http://unixodbc.org>).

There is also a freely available JDBC driver called jTDS
(http://jtds.sourceforge.net) which I have tried once or twice on VMS
and it seemed to work just fine.

There are several commercial products that may be of interest from
companies such as EasySoft, CONNX, Attunity, Information Builders, and
probably others, but what would work for you depends on what exactly you
mean by needing to connect your database to MS SQL Server.