利用Visual Basic及无线装置实现仪表数据远程传输  

Using Visual Basic and Wireless Device to Realize Remote Transmission of Instrument Data

作　　者：李国铸 李文胜 陈玉芝 曹冲 Li Guozhu;Li Wensheng;Chen Yuzhi;Cao Chong(Shandong Hualu-Hengsheng Chemical Co.,Ltd.,Shandong,Dezhou,253024,China)

机构地区：[1]山东华鲁恒升化工股份有限公司,山东德州253024

出　　处：《仪器仪表用户》2021年第8期22-25,共4页Instrumentation

摘　　要：由于还原为模拟信号的无线接收装置出现问题,仪表远传数据不能传输到DCS系统进行显示。使用还原为通讯数据的无线接收装置,利用Visual Basic语言自行开发软件,并运用MSComm控件通过微机的RS232串口发送Modbus指令到无线接收装置,实现数据的正确读出。用ODBC方式连接Mysql数据库实现数据的存储及数据表形式的查询显示,用TeeChart控件实现测量数据的实时和历史趋势图,开放远程微机Mysql数据库的网络功能,借助OA网络在多台微机上扩展应用功能,实现了灵活的数据监控方案。Due to the problem of wireless receiving device which is restored to analog signal,the instrument remote data cannot be transmitted to DCS system for display.Use wireless receiver which is restored to communication data,and develop software by visual basic language,use MSComm control to send Modbus command to the wireless receiver through RS232 serial port of microcomputer to realize the correct reading of data.The data storage and data table form query display are realized by connecting MySQL database by ODBC.The real-time and historical trend map of measurement data are realized by TeeChart control,share the network function of remote MySQL database,extend the application function of multi computers by OA network,and flexible data monitoring scheme under abnormal condition of equipment is realized.

关 键 词：远程传输 串口 MODBUS Visual Basic MYSQL 

分 类 号：TP29[自动化与计算机技术—检测技术与自动化装置]