2

I want to connect from a COBOL/VMS system to an SQL Server 2005 instance. Could someone point me to a driver that works well?

Michael Kristofik
  • 34,290
  • 15
  • 75
  • 125
hawkeye
  • 34,745
  • 30
  • 150
  • 304

3 Answers3

1

This is similar to another question on SO. Though not specific to VMS, many of the options presented there would work with VMS/ODBC.

You may also want to look at FreeTDS (I've used it many times but never from VMS) if you are looking for an open source implementation you can customize. Otherwise, the supported/commercial vendors that have products that would work include Attunity, DataDirect, EasySoft, and CONNX.

Community
  • 1
  • 1
boydc7
  • 4,593
  • 20
  • 17
  • True - edited to reflect, though most presented options there would work on most/many VMS platforms. – boydc7 Jan 04 '10 at 15:28
0

You can have native connectivity to VMS files through Attunity Connect

Nitya
  • 11
  • 3
  • 1
    The question assumes a multi-datasource environment (ie VMS is not the only source of truth) so the linkage was the other way around VMS -> SQL Server, not external to VMS. – hawkeye Apr 21 '11 at 11:03
0

We currently do this from Pascal on VMS by calling a C procedure which in turns calls a Java class via JNI. The Java class uses JDBC to access the SQL Server database. There is no reason a similar thing couldn't be done from COBOL.

If you didn't want to do the JNI stuff, you could write a socket server in Java which accepted messages sent from the COBOL program and then did the update across to the SQL server database.

ChrisB
  • 96
  • 2