关于WinCC利用ODBC从Oracle中读取数据的研究与应用

山东某钢厂棒材生产线进行改造,在精轧机后面增加KOCKS四机架三辊减定径机组。KOCKS的轧制表数据由BAMICON系统计算给出,并且存储在Oracle数据库中。自动化系统需要在Oracle数据库中读取轧制表数据,应用在轧钢生产中。自动化系统选用西门子S7-400控制系统,上位软件选用Win CC软件。通过编辑VB脚本程序,完成Win CC软件对Oracle数据库数据的读取,实现控制系统与轧制表数据库的数据连接。

New KOCKS RSB is placed after finishing mills in an iron and steel factory in Shandong.In this project,setup data of product is calculated by BAMICON system,and stored in Oracle database.The automation system needs to read setup data from Oracle database,and use the data in producing.Automation system is SIEMENS S7-400 system,and HMI software is WinCC software.By using VB script,WinCC read setup data in Oracle database,achieve communicating between automation system and Oracle database.