1、PrepareSQLDATABASE,inthisscenario衡痕贤伎s,weuseSQLserver2008R2EnableSQLserv髫潋啜缅ersecurityandcreateauser“sa”withpassword.
2、Createadatabaseandnamedas“test1”,createtwocolumnasbelow
3、createODBC,ifyouuse64bitsystem,pleaseopenbelowEXE“C:\Windows\SysWOW64概嗤先眚\odbcad32.exe”Thecreationprocedureasbelow
4、configureKepwareEX,weneedconfigure“Channel/device”,”Advancedtag”
5、1configureChannel/deviceCreateasimulatordevicetosimulatePLCsi爿讥旌护gnal.“BatchID”isatagcangetdatafromSQLtable
6、IcreateanODBCclientchannelanddevicetocommunicationwithSQLserver.
7、Icreateadeviceusing“Fixedtable”
8、2configureAdvancedTag.
9、SQLtoprocessdevicecommunicationTestingresult:
