基于VB开发工业以太网主机与Oracle服务器的接口程序  

Development of the Interface Program between Industrial Ethernet Hosts and Oracle Server Based on VB

作　　者：姚彬[1] 王进华[1] 康孝顺 

机构地区：[1]福州大学电气工程与自动化学院,福建福州350108 [2]福州福大自动化科技有限公司,福建福州350008

出　　处：《电气自动化》2010年第4期35-37,46,共4页Electrical Automation

摘　　要：应用VB中的TextBox控件与Intouch组态软件通信,来读取生产数据,并将数据打包,通过Winscok控件发送到Oracle服务器,Oracle服务器接收内网数据,再通过引用ADO部件,实现与Oracle数据库的连接,并将数据写入到Oracle数据库;采用这种经济、简单、适用的方法,成功的解决了由于正向型隔离器的使用而带来的无法通过在以太网主机中直接应用Intouch组态软件编写SQL语句将数据写入到Oracle服务器的问题。The production data are read and packed through the TextBox control and Intouch configuration software communication.Then with the help of Winscok control,the data are sent to the extranet server which receives the Intranet data by means of ADO components.The connection between production data and Oracle data base on which the former data are written is realized.Caused by the use of the positive-type isolator the problem is impossile of writing the data by the SQL statements into Oracle server through the direct application of Intouch configuration software in the ethernet hosts,is successful resolved by this economical,simple and suitable approach.

关 键 词：VB Oracle 正向型隔离器 WINSOCK ADO 

分 类 号：TP31[自动化与计算机技术—计算机软件与理论]