How can i get out the data from sqserver 2000. I have some tags and i want there values. In what intervals is the program stores the value of the tags? In which table sould i look an what is the structure of the table ex. tagname ts value ? something like that? WWW_P※LCJS_CO※M－PLC－技－.术_网
If you wont to read data from SQL without connectivity pack you need to save them in TagLogging Slow. If data are stored in tag logging slow they are not coded so it is eazey to read them. So go on: WWW_PLCJS_COM－PLC－技.术_网
************************************************** *************** W1WW_P4LCJS_COM－PLC－技.术_网
Tag logging->Archive Configuration->TagLoggingFast->Archive contents WWW_PLCJS※COM－PLC－技.术_网(可※编程控※制器技术门户)
1.unmark acyclic measured values WWW_PLCJS_COM－PLC－技.术_网
2.cyclic meas. values with cycle set on 1×500ms <------------- WWW_PLCJS@_COM%－PLC－技.术_网
| WWW_P※LCJS_CO※M－PLC－技－.术_网
Tag logging->Archive Configuration->TagLoggingSlow->Archive | P.L.C.技.术.网——可编程控制器技术门户
configuration | WWW_PLCJ－S_COM－PLC－技.术_网(可－编程控－制器技术－门户)
1. time perriod of all AND single set on MAX cca 5 Gigabytes | WWW_PLCJ－S_COM－PLC－技.术_网(可－编程控－制器技术－门户)
2.cyclic meas. values with cycle set on 1×500ms | WWcW_PLCJS_COM－PLC－技.术_网
| ——可——编——程——控－制－器－技——术——门——户
Acquition cycle of each tag in Archive MAST BE > 1×500ms------ WWW_PLCJ－S_COM－PLC－技.术_网(可－编程控－制器技术－门户)
plcjs.技.术_网
on the end you need to reset archive: WWW_PLC※JS_COM－PmLC－技.术_网
Archive Configuration->TagLoggingSlow AND TagLoggingFast->RMB-> RESET WWW_PLC※JS_COM－PLC－技.术_网(可编程控※制器技术门户)
WW.W_PLC※JS_C,OM－PL,C－技.术_网
************************************************** *************** WWW_P※LCJS_COM－PLC－)技.术_网
Go on EXCEL-> Data->Get externel data->New database query-> .....