Research on the Remote Data Collection Based SQL Server

The remote data collection system based on SQL Server database technology was developed by Visual C++ and SQL Server database technology together. The Client/Server mode was adopted. The system adopted the database search technological-ADO to work out the communication procedure of the server. And the old data of corresponding memory units were upgraded by the new data which gathered from PLC through serial port real time in the database. The Client utilizes the network technology and database technology through queries procedure to access the data information in the database. Thus a large number of relevant data that the production line operated were obtained. The goal of understanding operation conditions of product line was achieved through analysis of these data. This system has been debugged by the experiment successfully.