| 基于OPC技术的组态软件与SQL Server数据库的通信研究 |
| |
| 引用本文： | 孙淳.基于OPC技术的组态软件与SQL Server数据库的通信研究[J].实验技术与管理,2012,29(5):143-146. |
| |
| 作者姓名： | 孙淳 |
| |
| 作者单位： | 天津轻工职业技术学院科研设备处,天津,300350 |
| |
| 摘 要： | 介绍了运用OPC规范接口技术实现一种OPC Client软件功能,解决了现场数据通过OPC Server到SQL Server数据库集成的问题。给出了基于OPC技术的客户端第三方软件和MCGS组态软件服务器实现网络数据通信的方法。阐述了在VC++下如何实现OPC客户端以及与MCGS组态软件的网络数据通信。软件采用OPC数据存取、ADO数据库访问、SQL Server对象管理等方法实现对文件数据源、OPC数据源、SQL Server数据源等的读写和OPC对象、SQLServer中的库、表等对象的管理和操作。最后给出的实验结果证明OPC Client软件能够实现组态软件与关系数据库的数据通信。
|
| 关 键 词： | 实时数据库 信息集成系统 MCGS |
Research of communication for MCGS and SQL Server based on OPC |
| |
| Sun Chun.Research of communication for MCGS and SQL Server based on OPC[J].Experimental Technology and Management,2012,29(5):143-146. |
| |
| Authors: | Sun Chun |
| |
| Institution: | Sun Chun(Department of Equipment for Scientific Research Tianjin Light Industry Vocational Technical College,Tianjin 300350,China) |
| |
| Abstract: | An application of OPC Client software based on the OPC standard interface technology is introduced and the communication of scene data through OPC Server to SQL Server database is obtained.The method of data communication between the third software on client and MCGS configuration software on server is discussed.And data communication between OPC Client and MCGS configuration software on server under the VC++ environment is expatiated.Multiple technologies such as the OPC data access,ADO database access,SQL Server object management are adopted.File data source,OPC data source,SQL Server data source read-write and OPC object,library and chart of SQL Server data source are managed and operated.Data communication between configuration software and relation database is achieved by the OPC Client software proved by experimental result. |
| |
| Keywords: | real-time database information integration system MCGS |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
