获取 VMS 的驱动程序以连接到 SQL Server 2005
我想从 COBOL/VMS 系统连接到 SQL Server 2005 实例。有人能给我指一个运行良好的驱动程序吗?
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
这类似于另一个问题。虽然不是特定于 VMS,但其中提供的许多选项都可以与 VMS/ODBC 配合使用。
如果您正在寻找一个可以定制的开源实现。否则,拥有可用产品的受支持/商业供应商包括 Attunity、DataDirect、EasySoft 和CONNX。
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.
您可以通过 Attunity Connect 与 VMS 文件建立本机连接
You can have native connectivity to VMS files through Attunity Connect
目前,我们通过调用 C 过程从 VMS 上的 Pascal 执行此操作,该过程又通过 JNI 调用 Java 类。 Java 类使用 JDBC 访问 SQL Server 数据库。 COBOL 没有理由不能完成类似的事情。
如果您不想执行 JNI 操作,您可以用 Java 编写一个套接字服务器,它接受从 COBOL 程序发送的消息,然后对 SQL Server 数据库进行更新。
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.