如何Kepware之间的数据交换与处理装置SQL数据库
工具/原料
KepwareEXV5.X
Driver：ODBCClient，Simulator
Plug-in：AdvancedTag
SQLServer2008R2
方法/步骤
1、PrepareSQLDATABASE,inthisscenario衡痕贤伎s,weuseSQLserver2008R2EnableSQLserv髫潋啜缅ersecurityandcreateauser“sa”withpassword.
2、Createadatabaseandnamedas“test1”,createtwocolumnasbelow
3、crea隋茚粟胫teODBC,ifyouuse64bitsystem,pleaseopenbelowEXE“C:\Windows\SysWOW64概嗤先眚\odbcad32.exe”Thecreationprocedureasbelow
4、configureKepwareEX,weneedconfigure“Channel/device”,”Advancedtag”
5、4.1co艘绒庳焰nfigureChannel/deviceCreateasimulatordevicetosimulatePLCsi爿讥旌护gnal.“BatchID”isatagcangetdatafromSQLtable
6、IcreateanODBCclientchannelanddevicetocommunicationwithSQLserver.
7、Icreateadeviceusing“Fixedtable”
8、4.2configureAdvancedTag.
9、SQLtoprocessdevicecommunicationTestingresult:
