{var%20f='http://v.t.sina.com.cn/share/share.php?appkey=1515056452',u=z||d.location,p=['&url=',e(u),'&title=',e(t||d.title),'&source=',e(r),'&sourceUrl=',e(l),'&content=',c||'gb2312','&pic=',e(p||'')].join('');function%20a(){if(!window.open([f,p].join(''),'mb',['toolbar=0,status=0,resizable=1,width=440,height=430,left=',(s.width-440)/2,',top=',(s.height-430)/2].join('')))u.href=[f,p].join('');};if(/Firefox/.test(navigator.userAgent))setTimeout(a,0);else%20a();})(screen,document,encodeURIComponent,'','','https://www.manongdao.com/data/attach/logo/logo.png', '推荐 小情绪 Triste * 的问题《Getting a driver for VMS to connect to SQL Server》','https://www.manongdao.com/q-871682.html','页面编码gb2312|utf-8默认gb2312'));){kind=link}
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?
相关问题
- sql execution latency when assign to a variable
- What is the best way to cache a table from a (SQL)
- php PDO::FETCH_ASSOC doesnt detect select after ba
- Bulk update SQL Server C#
- SQL to Parse a Key-Value String
相关文章
- Entity Framework 4.3.1 failing to create (/open) a
- Code for inserting data into SQL Server database u
- How do I get to see DbgPrint output from my kernel
- Delete Every Alternate Row in SQL
- Linux based PHP install connecting to MsSQL Server
- SQL Azure Reset autoincrement
- How do we alias a Sql Server instance name used in
- Is recursion good in SQL Server?
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.
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.
You can have native connectivity to VMS files through Attunity Connect