The Application Research Of Using OPC Technology And SQL Server In The Configuration Sotfware Development

As the continuous development of microelectronic technology, computertechnology and communication technology and its depth applications in the field ofindustrial control, the development of configuration software that is the monitoringsoftware platform which used in industrial control systems has become moresophisticated. As for some small-scale enterprises and projects,however,there aresome drawbacks in most of the mainline configuration software systems on themarket, such as higher cost,no-opening source code,which influencing the expansionof configuration software applications in some small or medium-sized project system.In order to solve the above problems, an overall development programmer based onVisual C++software development platform, OPC technology and SQL Server hasbeen presented in this thesis.As the structural characteristics and development process of the Visual C++software development platform(Visual Studio2010Integrated DevelopmentEnvironment) has been analysed,this article designed the overall framework structureof the configuration software-based MFC application framework.Based on COMtechnology and OPC communications specification,the article developed anintegrated OPC client application programming interface so that the RTDB ofconfiguration software and on-site controller data systems could been linked closely.Take into consideration that the configuration software which has been developinghas characteristics such as field data communication is relatively small and thecharacter of real-time must be better, and combined the implementation methods ofOPC client interface program, the thesis developed a data dictionary(RTDB module)in which the OPC Client has been integrated. In order to ensure the open nature andscalability of the history database system, the article using the relational databaseSQL Server as the history data container. Compared Visual C++developmentplatform for database operations, the data archiving module based on ADOtechnology has been designed to achieve the classification and archiving ofconfiguration data.The configuration software design ideas presented in this thesis hascharacteristics such as openness and flexibility,and mature software developmenttechnology has been used when the core functionality module of the configuration software is developing,therefore,the stability and reliability of the targetconfiguration software also been guaranteed. Meanwhile,the realization of somefunctions has been optimized in the software development process, so that it will bemore suitable for the application of small business or project and it will not only beable to play good value for money in practical applications but also can get betterpromotion.