|
| Data Logger Suite:
ASCII - . ASCII - , , . Windows ASCII. ASCII * .TXT (, README.TXT).
Binary File - , , ASCII ( 0 255).
Bytes () - , , .
Bit () - . : 0 1. 8 8 () .
Cable () - . , .
Internet () - , TCP/IP . .
PC () - Personal Computer ( ).
Ports () - .
Protocol () - .
(Log file) - , , (. log) — .
:
•Windows 2000 SP 4 - Windows 10 ( x86 x64, ).
.
-, .
Data Logger Suite.
.
, Data Logger Suite "\Programs Files\Data Logger Suite" , .
Data Logger Suite , .
Data Logger Suite .
Data Logger Suite "".
(. 1), - , , . . , . , , . (" - ..."), "" (. 2) - .
. 1.
. 2. ""
, , - C:\. , , .
1-2-3-4
1. . :
"" . " IP" .
2. ( ).
" " . ( ).
3. , .
" " , , , , . , .
4. Data Logger Suite , .
Data Logger Suite , , .
, .
- -, . - . -, , -.
(. .). . , . " ", Data Logger Suite .
. - . Data Logger Suite. Data Logger Suite (plug-ins), . . . "".
, (. .) ( ), .
. .
. 3.
:
- ( ).
- ( ). , . , .
, .
•Core engine - , •Device layer module - •Data query module - •Data parser module - •Data filter module - •Data export module - •Visualizer - •File logging engine - - •Windows service wrapper - •External logging module - •Events handling module -
Windows.
1. - .
2. .
:
1. . "". , "". 2. Windows. regedit.exe :
Windows x64
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\AGG Software\Data Logger Suite
Windows x32
HKEY_LOCAL_MACHINE\SOFTWARE\AGG Software\Data Logger Suite
.
3. "" :
Ctrl+S - "/" ;
Ctrl+D - "/ ";
Ctrl+P - ;
Ctrl+L - log-;
Ctrl+R - ;
Ctrl+E - Windows;
Ctrl+M - , .
4. , ..: -
5. INI . . "".
6. 10 , : - .
(COM)
(. 4) "". , , (. 4). . " COM " .
. , . "" (. 4).
. 4.
COM- . COM- COM- . ( , ..) " " (. 4).
. 5. COM-
RS 485 - RTS. . RS232-RS485.
" " " " (. 6) RS232. " " , . , .
" RTS" " DTR", , .
" CTS" " DSR", .
, RTS CTS , DTR DSR RS232.
, .
" ", "" "" "".
Xon - , .
Xoff - , .
Xon Xoff 10% 90% .
, .
. 6
./. - . COM . .
Data Logger Suite , , .
, . , , . -.
, Data Logger Suite , .
, .
UART (UART receiver parity error) - , .
UART (UART receiver overrun),
UART (UART receiver framing error) - , , . .. , .
CTS (transmit timeout waiting for CTS),
DSR (transmit timeout waiting for DSR),
RLSD (transmit timeout waiting for RLSD) - , .
(transmit queue is full) - , Data Logger Suite ;
break (break condition received) - BREAK .
. Windows NT , . , " - " .
TCP/IP
UDP TCP
TCP (Transport Control Protocol) UDP (User Datagram Protocol). TCP , , , IP. TCP , ‘ ’ . TCP , TCP . , UDP , - , . UDP .
UDP , . TCP, UDP IP . TCP, UDP . , . - . UDP Instant Messaging, IP.
Data Logger Suite . . TCP/IP , .
( TCP/IP) Data Logger Suite :
1. | . IP , TCP/IP, . IP , Data Logger Suite , ( www.yourserver.com) . , , "Plant1", "Plant1" IP , IP . , Data Logger Suite IP . IP ; |
2. | . IP , , , . , Data Logger Suite IP (NIC), . IP , . , Data Logger Suite , , IP . Microsoft Windows, TCP/ IP . IP IP . |
, , "OK" , Data Logger Suite TCP/IP. , IP . , Data Logger Suite . , , .
, Data Logger Suite . , (. .). , .
, (. .) "". , , (. 7). . " IP" .
TCP/IP . , . "" (. 7).
. 7.
" IP" TCP/IP: IP . IP , "".
. 8. TCP/IP
IP , , . , . . , , SMTP - 25, the telnet - 23, NNTP - 119, .. , SERVICES, Windows ( Windows NT WINNT\SYSTEM32\DRIVERS\ETC). SERVICES - , Data Logger Suite ( , ) ( , ). . , . , , . , .
IP (socket). . , . , , , , . . , , , IP , . . , "" . IP ( ). , .
( ) ( ) , " ", Data Logger Suite . N , " (c)".
- IP
, . IP , , . . - . , Data Logger Suite IP . " ".
IP : 192.255.255.255
IP , 255 .
IP "+" "-" IP . IP .
"+" - .
"-" - .
:
+192.168.1.255
+127.255.255.255
-1.1.1.1
(firewall)
Microsoft Windows XP SP2 , Data Logger Suite . Windows Firewall, , , . Windows Firewall , , , (Security Alert). :
. 9.
:
• ; • ; • , .
, .
: , , , , .
"" TCP/IP (. 10).
- . .
- 1500 , , .
"TCP/IP ":
- . .
() - , , . "-1", .
. 10.
TCP/IP :
keep-alive TCP ( ) - , , . , , , . "" keep-alive, , Windows.
1. - . .
2. - KeepAliveTime KeepAliveInterval, :
[HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters]
KeepAliveTime (, 32 ) =
KeepAliveInterval (, 32 ) =
, .
3. - . , . 60/1 ( 60 1 ).
: . keep-alive .
: , , , , .
1. ( , ) . 2. . 3. . bps ( ) - 2400, 9600, 14400, 16800, 19200, 28800, 33600, 56000 bps. bps. , 4.Hayes - - , , -. -.
TAPI -
TAPI Telephony Application Programming Interface. TAPI - , , , , . TAPI , . TAPI , , . , TSPI (Telephony Service Provider Interface). , . . . .
. , . : " " . / . , , "Break the connection" c "The module didn't send/receive the data", . , , "Break the connection" "After the connection was established". , "Break the connection" c "The module didn't send/receive the data" . .
AT-
" " - "AT-" - AT-. AT :
AT-:
. 11. AT-
- ( 255 ). , , AT- . AT- , . :
- . , "OK". , .
- . , "" "" - . , .
- . , "OK". , . , .
- . , , .
- . , , .
- / . - .
- / . - .
AT-:
. 12. AT-
- , . . , . , . - .
- / RS232. - 9600 /.
- , /. : 5 - - 2; 6, 7, 8 - 1.5. - 8.
. - - . : 5 - - 2; 6, 7, 8 - 1.5. - 1.
- . - .
DTR - / DTR. - .
RTS - / RTS. - .
DSR - , , DSR. - .
X OnXOff - / XOffChar. , , XOffLim XOffChar. , , XOffLim XOnChar . - .
- (flow control), (XON/XOFF), (RTS/CTS DTR/DSR). - .
Xoff - Xoff ( )
. : # - # - , - . - #19.
Xon - Xoff ( )
. : # - # - , - . - #17.
TAPI-
" " - "TAPI-" - TAPI-. " TAP" :
TAPI-:
. 13. TAPI-
- TAPI-, . , . , . , . .
TAPI-:
. 14. TAPI-
- , ( ..) . - -1.
- / . "", . -1, .
- TAPI (, ..) , (.. , ). . (, ..) , .
, . . , , , / . , , , , . . " " .
" " - . .
. 15.
- "" ( ) "..." . " " "". "OK" - . , "". (. " ").
- "" ( ) "" . "" - . , "". , .
- "" ( ) "" . "OK" - . , "". , .
- "" ( ) "" . "OK" - . , "". , .
- "..." ( ) "..." :
" " " " "OK" - , " " . , "". , .
- "" ( ) "" - . , , .
- "" ( ) "" - . , , .
: . , .. - , - .. . , . / , , " ". " " , , .. " ". , " ", , , , .. , . , .
2 : " " " ", .
" ":
• • • • • •
" ":
• • • • • • • /
"" ""
. 16.
- : "Establish the connection" "Break the connection". - "Establish the connection".
- , . , , , .. - 500 . - 10.
() - ( ) . - 3600 . - 15 .
- , . , , . . , "OK". . :
- . , "OK". , .
- . , "" "" - . , .
- . , "OK". , . , .
- . , , .
- . , , .
- / . , , , "" "" - . () 0, , , - , , "", . - .
() - ( ), , . 0, , , - . - 20 .
""
. 17. ""
- . , . - .
: " ". - .
""
. 18. ""
- . , . - .
- . , "OK" . - .
: " " "". - .
" "
. 19. " "
- . , . - .
- , . , 0, . - 1 .
- , . , "OK". - .
: " " " ". "". " " , " " "". "" . - .
" "
. 20. " "
- . , . - .
- , . , 0, . - 1 .
- , . , "OK". - .
: " " " ". "". " " , " " "" " ". "" . - .
""
. 21. ""
- . , . - .
- , . , 0, . - 1 .
: " ". "". " " , " " "". - .
" ":
.
: "/" . - .
" "
. 22. " "
- , . , 0, , . - 1 .
: "" . - .
" / ":
- , . , 0, , . - 1 .
: "" , , . - .
OPC
, . . OPC. , . OPC , , . , OPC .
OPC :
1. " ", . , ( ), . , . " " " NULL ", .. , : NULL , , , . . 2. " " , . " " " NULL ", .. , : NULL , , , .
, " ". ";", """, "['", "]" "_". , "\", """ "\\", "\"", $00..$1F, "\x".
OPC :
1. ; 2. . "CR" "CR+LF"; 3. . ";"; 4. , , ( ), , ( ), . , : , "", , , "integer", , , "double". ""; 5. . , , .
,
. "OPC , ". / , , . , , , , , .
" OPC" - . .
OPC
. 23. OPC
- , OPC .
OPC , - , / .
- OPC , , , , / . - , "".
. 24.
. 25.
"" "OPC , " - (. 24 . 25). " ...", (. 26).
. 26.
- . . - XXX, XXX - .
() - OPC . . - 1000 , .. 1 .
(%) - . - 0 .
- . , ( ), - ( ). - .
- / . , , ( " " " NULL "), - .
- , . .
- , , . .
- , , .
- , , " ", , .
- / . , , OPC_QUALITY_GOOD, - . - .
- , .
- OPC , OPC UTC+0. , . , OPC OPC .
, – " " . :
ITEM_NAME[8]="opcserversim.Instance.1.T1";ITEM_VALUE[3]=1606521099;ITEM_QUALITY[3]=192
ITEM_NAME[8]="opcserversim.Instance.1.T2";ITEM_VALUE[3]=1170485188;ITEM_QUALITY[3]=192
ITEM_NAME[8]="opcserversim.Instance.1.Val1";ITEM_VALUE[5]=4958.32440443337;ITEM_QUALITY[3]=192
ITEM_NAME[8]="opcserversim.Instance.1.Val2";ITEM_VALUE[5]=4970.36790242419;ITEM_QUALITY[3]=192
, .
NULL - . , , , , - . - .
: " ".
"OK" "" - . .
"" "OPC , " - . " ...", (. 27).
. 27.
- OPC .
- OPC .
- ( ).
- .
DA - DA.
- .
- , "" , . "" .
- / . 2 :
1. 2.
- . , / "OK" . . . (. 28), .
. 28.
- .
- .
- .
- .
- . .
- . .
- . .
- . .
. 29.
- . - .
"" "OPC , " - . "", . "", . , "". "" .
"" "OPC , " - . "...", (. 30).
: , , .
" ".
: " ".
"OK" "" - .
"" "OPC , " - . "...", .
, "" , . "".
: , , .
" ".
"" "OPC , " - . " ", . "OK" - . , , , .
1: / , , . , , .
2: , , .
"" "OPC , " - . "" - . , .
"" "OPC , " - . "" - . , .
: .
OPC HDA
OPC HDA . . , 30 .
, . , (. .) " - ". , . , .
OPC AE
OPC AE . :
:
. :
* - .
? - .
:
Simulated Event:*
Simulated Item Creation Event:*
aaaa :: :*
*:*
:
*:*
OPC UA DA
:
opc.tcp://login:password@127.0.0.1:10000/url
127.0.0.1 - IP , . IP .
10000 - IP .
login:password - ( ) , . . , .
, " " OPC , ( LDS GDS , 4840). LDS , IP "" "" (. .).
, :
• (None). • (Sign). • (Sign&Encrypt).
:
•Basic128Rsa15 •Basic256 •Basic256Sha256
, OPC .
"Cron"
Cron- - , . ( Unix) cron- , :
<> <> <> <_> <> <_>
* () . . , , . . "" - ?. . .
, (, 1,3,7) () , (, 1-5).
(*) / . , 0-23/2 "" , ( - 0,2,4,6,8,10,12,14,16,18,20,22). */4 "" , . 1-30/3 - , 1,4,7,10,13,16,19,22,25,28.
"" " " (Jan, Feb, ... , Dec) (Mon, Tue, ... , Sun)
: <> .
|
|
* * * * *
|
|
59 23 31 12 5
|
, -
|
59 23 31 Dec Fri
|
, - ( )
|
45 17 7 6 *
|
7- 17:45
|
0,15,30,45 0,6,12,18 1,15,31 * 1-5 *
|
00:00, 00:15, 00:30, 00:45, 06:00, 06:15, 06:30, 06:45, 12:00, 12:15, 12:30, 12:45, 18:00, 18:15, 18:30, 18:45, 1-, 15- 31-
|
*/15 */6 1,15,31 * 1-5
|
00:00, 00:15, 00:30, 00:45, 06:00, 06:15, 06:30, 06:45, 12:00, 12:15, 12:30, 12:45, 18:00, 18:15, 18:30, 18:45, 1-, 15- 31- ( )
|
0 12 * * 1-5 (0 12 * * Mon-Fri)
|
|
* * * 1,3,5,7,9,11 *
|
, , , ,
|
1,2,3,5,20-25,30-35,59 23 31 12 *
|
23:01, 23:02, 23:03, 23:05, 23:20, 23:21, 23:22, 23:23, 23:24, 23:25, 23:30, 23:31, 23:32, 23:33, 23:34, 23:35, 23:59
|
0 9 1-7 * 1
|
, 9
|
0 0 1 * *
|
, ,
|
* 0-11 * *
|
|
* * * 1,2,3 *
|
,
|
* * * Jan,Feb,Mar *
|
,
|
0 0 * * *
|
|
0 0 * * 3
|
|
cron- "?". , . . : - , , .
, :
? ? * * *
(, , ) - "" . , , 8:25, :
25 8 * * * *
:
•? ? ? ? * - __ ; •? * * * * - (, 10:15) : 11:15, 12:15, 13:15 ..; •* ? * * * - , ; •*/5 ? * * * - ( ) . . , , .
. SNMP, :
1. , . 2, ; 2. , . - ; 3. " ", . , . 1, . 4; 4. .
. 30.
. 30. . . , , .
- , . , . ASCII. - Data source #< >.
- , . - .
- . , . 31 ( , ).
. 31.
... - . . "OK". , , .
- . . "OK". , , - , .
- . , . "", . , .
... - . , , . , , "OK" .
... - . , .
... - . " " " ". . . , .
- . , .
- . , .
: . , .
. 32.
- , . : - . - Group < >.
() - , SNMP-. - 1000, .. 1 .
- / SNMP-. - .
- , , . , 2 , , . (, , , ). .
- , . , . , .
- , . , . - .
- . , , , . - .
- , : ITEM_NAME[< >]="< >"; ITEM_VALUE[< >] = "<>". . ITEM_NAME, ITEM_VALUE. - .
:
ITEM_NAME[256]=".iso.org.dod.internet.private.enterprises.2162.1.2.0";ITEM_VALUE[8]="computerName"
ITEM_NAME[256]=".iso.org.dod.internet.private.enterprises.2162.1.3.0";ITEM_VALUE[8]="1"
- , . , . - .
:
ITEM_DATETIME_STAMP[7]=01.03.2010 15:52:00;ITEM_NAME[256]=".iso.org.dod.internet.private.enterprises.2162.1.2.0";ITEM_VALUE[8]="computerName"
ITEM_DATETIME_STAMP[7]=01.03.2010 15:52:00;ITEM_NAME[256]=".iso.org.dod.internet.private.enterprises.2162.1.3.0";ITEM_VALUE[8]="1"
– , , . , "Cron".
. 33.
( IP) - IP- , . URL- (: www.aggsoft.com), IP- (: 192.168.1.1). 10 , , . - localhost.
- , ( ). - 161.
(Community) - ( ). - public. : "public" . . 10 .
- (. ). , .
OID - SNMP , " ". ".1.3.6.1.2.1", , MIB-II. MIB (Management Information Base) . , , .
- SNMP. . . " ". - . . 33. , (, .iso.org.dod.internet.private.enterprises). .
- SNMP. , .
- - , , . - .
SNMP (traps)
SNMP (SNMP traps, SNMP ), , 34.
, . , SNMP .
. 34. SNMP traps
SNMP OID ".*" ( ). OID , , SNMP (. 34).
- IP , SNMP . IP , "0.0.0.0" , IP .
- . - 162.
(Community) - community, , .
- "SNMPv2 Trap" . SNMP .
- OID .
- OID . OID .
. 35. SNMP
, , , OID.
, .
SNMP 2:
DATE_TIME_STAMP - .
TRAP_ID - SNMP .
TRAP_ERROR_STATUS - ( ).
TRAP_ERROR_INDEX - ( ).
SNMP ( 1):
DATE_TIME_STAMP - .
TRAP_GENERIC - .
TRAP_SPECIFIC - ( ).
TRAP_TICKS - , .
TRAP_HOST - , .
. , OID, IP ( ).
, "Mgmt/MIB-2/Interfaces/Table", OID ".1.3.6.1.2.1.2.2". (1, 2, 3 ..).
, - , "Mgmt/MIB-2/Interfaces/Table/Entry/Descr" OID ".1.3.6.1.2.1.2.2.1.2.X"
OID ".1.3.6.1.2.1.2.2.1.2.1", OID . , :
1: .1.3.6.1.2.1.2.2.1.2.{ENTRY:1-7}
.
2: .1.3.6.1.2.1.2.2.1.2.{ENTRY:1,3,5,7}
1,3,5,7.
IP , . , IP 192.168.1.10, 192.168.1.11, 192.168.1.12, , , , IP 192.168.1.{SUBNET:10-12}.
. 36.
. , . "IP " OID.
, : Group 192.168.1.{SUBNET} - Entry {ENTRY} , , 192.168.1.10 - Entry 1
( ): Descr{ENTRY}, , , Descr1.
. 37.
, , , . . , .
"Cron"
Cron- - , . ( Unix) cron- , :
<> <> <> <_> <> <_>
* () . . , , . . "" - ?. . .
, (, 1,3,7) () , (, 1-5).
(*) / . , 0-23/2 "" , ( - 0,2,4,6,8,10,12,14,16,18,20,22). */4 "" , . 1-30/3 - , 1,4,7,10,13,16,19,22,25,28.
"" " " (Jan, Feb, ... , Dec) (Mon, Tue, ... , Sun)
: <> .
|
|
* * * * *
|
|
59 23 31 12 5
|
, -
|
59 23 31 Dec Fri
|
, - ( )
|
45 17 7 6 *
|
7- 17:45
|
0,15,30,45 0,6,12,18 1,15,31 * 1-5 *
|
00:00, 00:15, 00:30, 00:45, 06:00, 06:15, 06:30, 06:45, 12:00, 12:15, 12:30, 12:45, 18:00, 18:15, 18:30, 18:45, 1-, 15- 31-
|
*/15 */6 1,15,31 * 1-5
|
00:00, 00:15, 00:30, 00:45, 06:00, 06:15, 06:30, 06:45, 12:00, 12:15, 12:30, 12:45, 18:00, 18:15, 18:30, 18:45, 1-, 15- 31- ( )
|
0 12 * * 1-5 (0 12 * * Mon-Fri)
|
|
* * * 1,3,5,7,9,11 *
|
, , , ,
|
1,2,3,5,20-25,30-35,59 23 31 12 *
|
23:01, 23:02, 23:03, 23:05, 23:20, 23:21, 23:22, 23:23, 23:24, 23:25, 23:30, 23:31, 23:32, 23:33, 23:34, 23:35, 23:59
|
0 9 1-7 * 1
|
, 9
|
0 0 1 * *
|
, ,
|
* 0-11 * *
|
|
* * * 1,2,3 *
|
,
|
* * * Jan,Feb,Mar *
|
,
|
0 0 * * *
|
|
0 0 * * 3
|
|
cron- "?". , . . : - , , .
, :
? ? * * *
(, , ) - "" . , , 8:25, :
25 8 * * * *
:
•? ? ? ? * - __ ; •? * * * * - (, 10:15) : 11:15, 12:15, 13:15 ..; •* ? * * * - , ; •*/5 ? * * * - ( ) . . , , .
, , (. log) — .
, , — () (, , ), .
. .
() . , , . . , - .
, , . , - . , ( ) email. , .
, , . , , - . . , :
1. "" - . 2. "" - .
, , .
. .
, . , (. " "). , , . , .. . :
1. ; 2. , .. ; 3. .
, .. "*.txt", - . . , , , .
, . , , .
"" - (. 38).
. 38.
- , . . - Data source #XXX, XXX - .
. "" - (. 39).
. 39.
- . (. 40). OK - . , "".
- . , "Yes" () "No" () - . , .
- (. 40). OK . , "". , .
- . .
- . , .
. 40.
- . . - .
- , . . .
: , {TIME}. , . . :
TIME, UTCTIME - Unix timestamp UTC.
YEAR, UTCYEAR - ( ).
YEAR2, UTCYEAR2 - ( ).
MON, MON1, UTCMON, UTCMON1 - 01 12 1 12 UTC.
DAY, DAY1, UTCDAY, UTCDAY1 - .
HOUR, UTCHOUR - 00 23.
MIN, UTCMIN - 00 59.
SEC, UTCSEC - 00 59.
- / . - .
- . - 9999.
: . :
C:\Files\Data\Test -
C:\Files\Data\Test\Folder0 - 1
C:\Files\Data\Test\Folder0\Folder1 - 2
..
: , , , , "".
" " - (. 41).
. 41.
- : "" "". "" . "" . . "" , "" . - "".
""
- , . , . : *.* - , *.txt - , *.exe - . - *.*.
() - , . - , - . . - 512 .
- . , : (), () (). , . - 1 ().
() - . , .. . - 500 .
- . . - .
- , . - .
- , . - .
- , . - .
""
, "", .
() - . - 30 .
"" - - (. 42).
. 42.
:
1. ( " "); 2. ( " "). 0:00:00-0:00:00, .
, , , .
DDE
Dynamic Data Exchange (DDE) — Microsoft Windows. Windows, — OLE, COM Microsoft OLE Automation. DDE Windows, , . .
/ DDE . (. ", "). , , .
, . , . DDE , DDE (DDE items). , . DDE DDE . DDE . , , .
,
. , . , . .
DDE
", DDE" (. 43). , , , , , "" . ( ), .
. 43. DDE
(Data source name) - , , .
, DDE - , / .
(Action) - DDE , , , , / . (. 44).
. 44.
" " . (. 45).
. 45. .
- . . - Group ###, ### - .
() (Update rate) - . , DDE , , . . - 1000 , .. 1 .
(Active) - . , .
NULL - , , .
- , , , . , .
- , , .
- , , , DDE . , DDE , DDE .
- , , , .
- , , . , , . " ".
- , , .
: UPDATE_DATE_TIME[7]=2011-09-27 14:09:34
- , , , UTC.
- , . , , .
: ITEM_NAME[8]="Item2Const";ITEM_VALUE[8]="Time=27.09.2011 0:00:00";UPDATE_DATE_TIME[7]=2011-09-27 14:09:34
" DDE" . (. 46).
. 46.
- DDE .
- DDE .
(Topic) - DDE .
(Item) - DDE .
- . DDE . . , , .
"" (. .) .
"" .
" " , . , "Item1". , , .
"" "" . , .
DDE .
- , , . , , .
- , , . , DDE DDE .
. 47.
SQL SQL- (, Microsoft SQLServer, Firebird, MySQL, PostgreSQL, Oracle ..) . , SQL--DDE SQL--OPC, TCP .
. , , , (, Microsoft SQLServer Oracle).
, ODBC- . ODBC , .
SQL .
. " " (. 48).
. 48.
- , , .
- .
"" ( " ").
" " :
•DB2, Informix ODBC – DSN, " ODBC", , . Informix: SERVICE=ids_srv;HOST=yourhost;PROTOCOL=OLSOCTCP;SERVER=ids_srv;DATABASE=sysmaster;UID=informix;PWD=informix.
•Interbase – ( ).
|
|
<server_name>:<filename>
|
TCP
|
\\<server_name>\<filename>
|
NetBEUI
|
<server_name>@<filename>
|
SPX
|
•Oracle – / (). •MySQL, MS SQL Server Sybase SQL Server – , . , remsrv:dbname DBNAME, REMSRV. (local).
"" "" .
" " , .
|
|
|
AUTOCOMMIT
|
auto-commit
|
|
APPLICATION NAME
|
,
|
MSSQL Sybase
|
HOST NAME
|
,
|
MSSQL Sybase
|
COMMAND TIMEOUT
|
,
|
MSSQL, ODBC, SQLBase, Sybase
|
COMPRESSED PROTOCOL
|
. True
|
MySQL
|
ENABLE BCD
|
NUMERIC BCD
|
Oracle, Interbase
|
ENABLE INTEGERS
|
NUMERIC INTEGER
|
Oracle, Interbase
|
ENABLE MONEY
|
NUMERIC (1-4) CURRENCY
|
MySQL
|
ENCRYPTION
|
. false.
|
Sybase
|
FIELD REQUIRED
|
, NULL
|
|
FORCE OCI7
|
OCI7 (SQL*Net 2.x - Oracle7 interface) Oracle
|
Oracle
|
LOCAL CHARSET
|
|
Interbase
|
LOGIN TIMEOUT
|
|
DB2, Informix, ODBC, MSSQL, MySQL, Sybase
|
MAX CURSORS
|
|
MSSQL Sybase
|
MAXCHARPARAMLEN
|
. 255
|
|
MAXFIELDNAMELEN
|
. 50
|
Oracle
|
MAX STRING SIZE
|
, blob
|
Firebird, Interbase, ODBC
|
NEW PASSWORD
|
, 'Password expired'
|
Oracle8
|
QUOTED IDENTIFIER
|
|
MSSQL Sybase
|
PREFETCH ROWS
|
, prefetched , (Oracle8: SELECT LONG)
|
DB2, Informix, ODBC, Oracle8
|
ROLE NAME
|
,
|
Interbase Oracle (SYSDBA/SYSOPER roles)
|
SERVER PORT
|
TCP/IP
|
MySQL, PostgreSQL
|
SINGLE CONNECTION
|
/ false
|
MSSQL Sybase
|
SQL DIALECT
|
SQL Dialect (1,2,3)
|
Interbase
|
TDS PACKET SIZE
|
TDS. , “Login failed”
|
Sybase
|
TRANSACTION LOGGING
|
FALSE, transaction logging, rollback
|
SQLBase
|
RTRIM CHAR OUTPUT
|
CHAR. True
|
DB2, Informix, Interbase, Oracle, ODBC Sybase
|
XA CONNECTION
|
, () TM , "Database name". False
|
Oracle8i
|
XXX API LIBRARY
|
, XXX , , Oracle, SQLServer, Interbase
|
|
, , " ". . ( ) . . , .
SQL
:
1. . . "SELECT".
2. SQL . . :
SELECT COL1, COL2 FROM DATA
. 49. SQL
- .
- , . , , .
USB
HID . , , . , USB , .. . HID .
. 50. HID
, - , . USB , , . , , . HID , . HID , .
- , , HID .
HID
USB USB , HID reports. , .
-
VID PID - , HID .
USB - , USB .
- , . , .
- , (RAW) .
- USB . , .
USB HID
USB HID MS SQL ( - )
USB HID MS SQL ( )
USB HID MySQL
USB HID Excel
. . , . .
(. .) 2 (. 51):
. 51.
" - " (. 51) , :
- . . . , , Hex- .
- . %d , %x - . .
- .
- : Windows DOS (OEM).
- , .
- . , , . 0, .
- . . 0, .
- . , , . , .
(. 52) () . .
. 52.
- . ( ) .
- , .
, - , (/).
- , .
- -.
- , , .
- . , . : >#0D#0A
(. 53) :
- . .
- , .
"" . , , .
- , "/" .
- , .
. 53.
-
- -. (. 54). - ().
. 54. -
, -, : . " ", .
, " ". , , , " ", . "OK". , , .
Data Logger Suite - - , - .
- :
• - , ; • . " " . , "sample", "log ", "", - "sampleYYYYMMDD.log". 21- 2003 - "sample20030321.log". • - , ( ).
, , , .
" " :
1. - , . DDMMYYYY, DD - , MM - YYYY - ; 2. - . MMYYYY; 3. - , YYYYMMDD; 4. - . , . : sample00000001.log. - ; 5. - ; 6. - . WWYYYY, WW - , YYYY - ; 7. - , ; 8. - . HHDDMMYYYY; 9. - - . , - , .
, "Schedule & Hotkeys", .
:
D - , (1 - 31);
DD - , (01 - 31);
DDD - ( - ) , ;
DDDD - ( - ) , ;
M - , (1 - 12);
MM - , (01 - 12);
MMM - ( - ) , ;
MMMM - ( - ) , ;
YY - (00 - 99);
YYYY - (0000 - 9999);
H - , (0 - 23);
HH - , (00 - 23);
N - , (0 - 59);
NN - , (00 - 59);
S - , (0 - 59);
SS - , (00-59).
W - ISO ( - ).
WW - ( ).
CLIENTID - ( ).
CLIENTNAME - ( ).
: - . , "sample_log", "txt".
: = sample_log_, = txt ( !). HHDDMMYYYY. . , , .
- №4 №7 / .
- , . , COM1-sample20030321.log.
/ - , .
- №4 №7. , .
-, " ". , . -:
1. - . ! 2. - . 3. ( ) - . . 4. ( ). , . . . , .
-
, -, .. , . , Microsoft Office (, Microsoft Word), Data Logger Suite .
. 55.
Data Logger Suite (. 55), :
• - , ; • , - , , . , ; • - .
, . .
- . - , (. 56).
, , .
, - .
. , .
. 56.
, , . ( , ), , .
"" (. . ).
Data Logger Suite :
• - ; • (, , ) - () , , ; • - ; • - , , Excel ; • (. 5.1.3) - , Data Logger Suite. , " -" " ". . , , .. .
. 57.
. 58.
. 59.
. , .
. . . , . . , "" . "" , , . , .
. , , "OK".
OPC
Data Logger Suite OPC. , , OPC Data Logger Suite . , (. 60). OPC OPC Core Components Redistributable www.opcfoundation.org ( ) , .
OPC . OPC .
. 60. OPC
Data Logger Suite, , , OPC (. 61). OPC .
. 61. OPC
" ". - , . .
. 62.
Data Logger Suite " ". Data Logger Suite - , , . OPC , , , . , (. 63). OPC , OPC , , .
. 63.
. 64.
" " (. 64) :
- Data Logger Suite , (. 65) ;
. 65. -
(. 65) - Data Logger Suite , ;
- ;
- / . .
- , . ;
- (, , );
- . ;
- Windows 2000 . - , - .
- , . .
(. 66) , .
. 66.
/ - . .
- .
- .
- , TX RX .
. - , . , COM1.
, (). , . " " , (. 67). . , + .log.
. 67.
Data Logger Suite 3- :
• - , ; • - . , ; • - , .
:
• - , ; • - , ; • - , ; • - , .
/ .
, , " " .
, , Data Logger Suite , . , " ".
() Windows :
• , , ( Windows 2000 ); • - ( ); • , ; • .
: , (, , , ). Windows Vista (elevated) .
, " " " Windows" (. 68). .
. 68.
:
, " ". (. 69). " ", .. Windows .
: Windows Vista .
. 69.
, Data Logger Suite, " " (. 68) .
, , "" (. 70).
. 70. ( Windows 2000)
2 - dataloggersuitesrv.exe dataloggersuite.exe (. 71). Data Logger Suite Data Logger Suite, . srvany.exe .
. 71.
. dataloggersuitesrv.exe :
•/? - ; •/I - ; •/A - ; •/D - ; •/R - .
. .
Windows Vista
Windows Vista , . , . . , . - .
, , . , , Windows.
• : Interactive Services Detection • : UI0Detect • : UI0Detect.exe •: , , . • : %windir%\system32\UI0Detect.exe • :
1.Home Basic: 2.Home Premium: 3.Business: 4.Enterprise: 5.Ultimate:
(. 72). , . , , . .
. 72.
. " ", .
, .. , .
, SoftIce - .
, , support page.
|