基于OPC技术的组态软件与SQL Server数据库的通信研究

Research of communication for MCGS and SQL Server based on OPC

介绍了运用OPC规范接口技术实现一种OPC Client软件功能,解决了现场数据通过OPC Server到SQL Server数据库集成的问题。给出了基于OPC技术的客户端第三方软件和MCGS组态软件服务器实现网络数据通信的方法。阐述了在VC++下如何实现OPC客户端以及与MCGS组态软件的网络数据通信。软件采用OPC数据存取、ADO数据库访问、SQL Server对象管理等方法实现对文件数据源、OPC数据源、SQL Server数据源等的读写和OPC对象、SQLServer中的库、表等对象的管理和操作。最后给出的实验结果证明OPC Client软件能够实现组态软件与关系数据库的数据通信。

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.