如何Kepware之间的数据交换与处理装置SQL数据库工具/原料moreKepware EX V5.XDriver：ODBC Client，Simulator Plug-in：Advanced TagSQL Server 2008 R2方法/步骤1/9分步阅读

PrepareSQLDATABASE,inthisscenarios,weuseSQLserver2008R2

EnableSQLserversecurityandcreateauser“sa”withpassword.

2/9

Createadatabaseandnamedas“test1”,createtwocolumnasbelow

3/9

createODBC,ifyouuse64bitsystem,pleaseopenbelowEXE

“C:\Windows\SysWOW64\odbcad32.exe”

Thecreationprocedureasbelow

4/9

configureKepwareEX,weneedconfigure“Channel/device”,”Advancedtag”

5/9

4.1configureChannel/device

CreateasimulatordevicetosimulatePLCsignal.

“BatchID”isatagcangetdatafromSQLtable

6/9

IcreateanODBCclientchannelanddevicetocommunicationwithSQLserver.

7/9

Icreateadeviceusing“Fixedtable”

8/9

4.2configureAdvancedTag.

9/9

SQLtoprocessdevicecommunicationTestingresult:

注意事项

更多kepware（凯普华）请咨询kepware中国区一级代理www.alliedsolutions.com.cn

kepware凯普华