Intouch2014 R2在win764位专业版系统中和MS Access数据库的数据交互-V1.0
- 格式:docx
- 大小:600.25 KB
- 文档页数:10
Intouch 2014r2授权到2021.4.14复制一下内容然后将文件名改成“ArchestrA Chinese.lic”#aacomponent:aaAdv Dev Studio 2020 Unlimited 30 Day Demo Consignment, Chinese|Adv Dev Studio 2020 Unlimited|P/N AdvStC-36-P-20|#Serial Number 2137502-0|ActiveFactory|ActiveFactory_Pro|ActiveFactory_RWS|Connectivity_Extension|Corp_ Energy_Mgmt_Event|Corp_Energy_Mgmt_Meter|DAServer|Dev_IO_Count|Dev_Session_Count |Dream_Report|Dream_Report_DevSeat|Dream_Report_Life_Science|Dream_Report_MES|Dre am_Report_SPC|Dream_Report_Web|GR_Runtime|Historian_HistoryDuration|Historian_Modify HistoryData|Historian_Processors|Historian_RemoteIDASCount|Historian_ReplicationServer|His torian_ServerOS|Historian_Tagcount|IDE_Runtime|InBatch|INBATCH_BATCH_OCX|INBATCH_DE VELOPMENT_CLIENT|INBATCH_OS_SECURITY|INBATCH_RUNTIME_CLIENT|INBATCH_SECURITY|I NBATCH_SERVER|INBATCH_SFC_OCX|INBATCH_TERMINAL_SERVER|Industry_Templates|InTouch |InTouch_TSE|INTOUCH_TSE_READONLY|INTOUCH_TSE_READWRITE|IO_Count|MES_Backgroun d_Process_Count|MES_BOM|MES_Certification|MES_Data_Editor_Count|MES_Datalog|MES_F actory_Connector_Count|MES_Folders|MES_Inventory|MES_Labor|MES_Operations|MES_Ope rations_Count|MES_Production|MES_Quality|MES_Quality_Count|MES_Quality_Spec_Count| MES_Session_Count|MES_Shipping|MES_Specifications|MES_Steps|MES_Storage_Count|MES_ Supply_Chain_Connector|MES_Utilization|MES_Utilization_Count|MXAccess_Runtime|OI_Serve r|Platform_Count|Quick_Reports|SPCPro|SVoyager_Portal|SVoyager_WriteEnable|WEI_Professi onalFEATURE ActiveFactory Wonderware 10.6 14-apr-2021 uncounted \HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00D0 812E 70BD 685E 04B3 8582 986A \EA00 D6F8 127E 1BAC CC1E F88C D7D0 4EB2"FEATURE ActiveFactory_Pro Wonderware 10.6 14-apr-2021 uncounted \HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0005 2B06 15B7 280C 03A2 C533 07A8 \FE00 0F31 7886 AE44 58EB B985 194E 9C7C"FEATURE ActiveFactory_RWS Wonderware 10.6 14-apr-2021 uncounted \HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0036 0313 F643 94C2 20DF D450 5F59 \9000 5782 212A 97AB A907 4DF4 110B C409"FEATURE Connectivity_Extension Wonderware 1.0 14-apr-2021 uncounted \HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0037 226F CE58 2ADC 02EC 310A 19A4 \3100 17EC C9B2 B251 2A5C 6132 610B DF8B"FEATURE Corp_Energy_Mgmt_Event Wonderware 2.1 14-apr-2021 uncounted \ VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="005D 7BFC 2647 91D1 E9E4 032A \ EDD7 5600 7C99 E32D 6D0D 667D 1473 9272 8702"FEATURE Corp_Energy_Mgmt_Meter Wonderware 2.1 14-apr-2021 uncounted \ VENDOR_STRING=count:150 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00E4 0D87 AB9D D17F FF37 8408 \ FAFA 9800 EBBB C9B1 B8EE 780F EFC0 E6E9 4945"FEATURE DAServer Wonderware 11.1 14-apr-2021 uncounted \VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0097 BB1B 6FB9 8C24 BFB6 45D6 \ 2C46 8300 EEA3 44BD B912 8EAD 7B82 15E4 239A"FEATURE Dev_IO_Count Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:1000000 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0002 AE9A DE3A \002C F164 B848 FFC8 7D00 31A7 2A76 8C64 B02B 14A0 2D21 1E2A" FEATURE Dev_Session_Count Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:5 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="004E D64B 6BFB A4C1 953F 4DE0 \ 3B0A 7800 C8E9 D9B6 60F2 B2C1 122F B6F4 5FFF"FEATURE Dream_Report Wonderware 5.0 14-apr-2021 uncounted \ VENDOR_STRING=tag:10000 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0022 D825 3663 DADA C61C F87F \ B2D2 B100 307E D59F D2BF 0CEE A1F9 E5B3 E684"FEATURE Dream_Report_DevSeat Wonderware 5.0 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00AD 9AFC C962 9C7F 6C1A FDA9 \ 54EF 4700 1A8C B267 147C AE14 13F8 5E90 EBB6"FEATURE Dream_Report_Life_Science Wonderware 5.0 14-apr-2021 \uncounted VENDOR_STRING=ls:1 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="00F4 255F 8BCD \ F097 DE27 4B59 9300 D800 3801 BE4D 6457 1A08 8279 DB32 CE5C" FEATURE Dream_Report_MES Wonderware 5.0 14-apr-2021 uncounted \ VENDOR_STRING=MES:1 HOSTID=ANY ISSUER="Invensys Systems, Inc." \ NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0051 57C7 E778 116E 777C 4CE8 \ 22D6 2400 7672 DB10 1756 4C86 A8DC 3C32 4F38"FEATURE Dream_Report_SPC Wonderware 5.0 14-apr-2021 uncounted \ VENDOR_STRING=SPC:1 HOSTID=ANY ISSUER="Invensys Systems, Inc." \ NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="003E 9409 46F6 2CC2 2131 4FA2 \ 1DB4 7E00 0AD5 26AF D89D 97A5 96FF E1DF 3942"FEATURE Dream_Report_Web Wonderware 5.0 14-apr-2021 uncounted \ VENDOR_STRING=count:0005 HOSTID=ANY ISSUER="Invensys Systems, \ Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0032 B780 FF17 53B4 7E4D C01E \ 39E7 A000 51B8 EF9A FC67 A422 9EFB 45B4 512A"FEATURE GR_Runtime Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="000C 81AC CCF7 7772 EBB3 675A \ EEFB E500 988B 233D BBBB 96A6 50FA 864E 96D4"FEATURE Historian_HistoryDuration Wonderware 11.6 14-apr-2021 \ uncounted VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys \ Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0016 E3AB AD72 \ 2AD4 D189 2D65 3B79 B000 71FB EAF9 BBDF 50C6 7FA1 55F0 9A69" FEATURE Historian_ModifyHistoryData Wonderware 11.6 14-apr-2021 \ uncounted HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0061 74EB 0AB0 B93B F074 69B0 \ 7F4C AA00 8CA0 2AFC 3B88 4501 49A5 F489 37B1"FEATURE Historian_Processors Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0008 0557 C02B 9F58 2327 2FC8 \ D8B1 3600 7B65 D5D3 6481 67CA 5D47 3F30 6897"FEATURE Historian_RemoteIDASCount Wonderware 11.6 14-apr-2021 \ uncounted VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys \ Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0080 9E00 1723 \ 83A6 B879 563D 925C D800 006A F63B BE05 7FB6 5B2F AC80 CB58" FEATURE Historian_ReplicationServer Wonderware 11.6 14-apr-2021 \ uncounted HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00A5 C130 E9D7 AF33 C5E6 7BB9 \ 14A3 A000 C795 2251 B9FF 632D 6071 FA67 61FA"FEATURE Historian_ServerOS Wonderware 11.6 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \ Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00FF A401 D33E DAE7 C5B8 DE70 A7A1 \ FA00 4ED6 6BF3 C7E7 67FD 80EF 11EB 2D0F"FEATURE Historian_Tagcount Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:150000 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0049 8133 5D15 \ 5E6D ECEE D2FF 9E83 5200 000E 5147 6827 8CCA C9D2 52C5 2D67" FEATURE IDE_Runtime Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00D2 2326 485F A3F5 2CCD 7B0C \ 22E8 DD00 2DF3 B4F4 510D 58B1 BB47 9A26 4D62"FEATURE InBatch Wonderware 11.6 14-apr-2021 uncounted \VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0080 447E 3A78 3EA6 E087 373F \ 6DE8 7F00 94A2 C3D2 D225 3BBD CB9F 8765 4D3E"FEATURE INBATCH_BATCH_OCX Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00E1 C01A 5495 B455 63ED C606 \756D DB00 41B8 BFBE 6A60 04BE 9AD3 3969 435D"FEATURE INBATCH_DEVELOPMENT_CLIENT Wonderware 11.6 14-apr-2021 \ uncounted VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0053 FDCA E30E \DD4B 5866 EEFC 4231 3C00 858D FF66 ABFD BD70 644C E13E 957E" FEATURE INBATCH_OS_SECURITY Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0022 4E09 7F48 7DB3 7D5C 284F \F2A8 6800 D9DC 0F47 5959 A8F1 9428 C74C 14BF"FEATURE INBATCH_RUNTIME_CLIENT Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00D4 ECAA 287F 5688 C689 4542 \56AD 3700 4564 8F47 7D55 68B6 2DDE FA84 AA75"FEATURE INBATCH_SECURITY Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0060 CD12 D4FF 4A87 0112 FABF \19C7 B400 41C5 8691 DA82 5589 E926 85D7 A21F"FEATURE INBATCH_SERVER Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0030 B587 1CE0 AA76 1334 066C \D269 C900 BE99 44AF 9939 4019 825F 8A2E 7644"FEATURE INBATCH_SFC_OCX Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00E4 E9CA 9FA4 CECD 08C6 6445 \F0A8 0C00 8EE8 A548 0575 26AB 3F31 068E 3B14"FEATURE INBATCH_TERMINAL_SERVER Wonderware 11.6 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00B3 1ABB 7F81 50E7 5867 019A \AD92 8400 42E4 B403 97F7 9FBE 6669 D07C D1E1"FEATURE Industry_Templates Wonderware 4.1 14-apr-2021 uncounted \VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="006B 650F 59B1 B481 665F 0BD8 \AB2B 2C00 399B 6F85 88A8 2C27 2060 E2D2 495F"FEATURE InTouch Wonderware 11.1 14-apr-2021 uncounted \VENDOR_STRING=ltags:61402;rrefs:61402;mode:3;lang:1 HOSTID=ANY \ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="001F 5F1B 4670 FD99 465D A68E 0942 \4500 2ACC D50B D64D E9F4 B334 EAEF 133A"FEATURE InTouch_TSE Wonderware 11.0 14-apr-2021 uncounted \ VENDOR_STRING=count:75 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00D3 BC83 2404 CE83 6856 9224 \5919 5600 3827 AC38 91FB 1F60 CF82 A9EA B2EE"FEATURE INTOUCH_TSE_READONLY Wonderware 11.1 14-apr-2021 uncounted \ VENDOR_STRING=count:75 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0056 C565 D0FB 201F 7CBE 3C90 \6260 CC00 ABCF 3799 284B AD18 C63C CA03 935A"FEATURE INTOUCH_TSE_READWRITE Wonderware 11.1 14-apr-2021 uncounted \ VENDOR_STRING=count:75 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00BD DDD8 1CD6 C6A7 2ED8 3909 \ 498D 9F00 B225 76C1 AB37 7699 4E7D 62F4 5B68"FEATURE IO_Count Wonderware 4.1 14-apr-2021 uncounted \VENDOR_STRING=count:1000000 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="0061 00B2 1BDB \131C 114B 619C E965 8200 E753 8AFF 220F 6631 0D9C 4259 FF0F" FEATURE MES_Background_Process_Count Wonderware 5.3 14-apr-2021 \ uncounted VENDOR_STRING=1 HOSTID=ANY ISSUER="Invensys Systems, \ Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00C2 8B62 72C7 1A2B A4CE 8985 \A136 2E00 DB95 7451 B1FF B826 DD8C 3613 C7DF"FEATURE MES_BOM Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0032 2478 F05F 3DA7 5451 C9E2 4AE0 \3400 7CDB FA9E 3E77 6D0B 3F40 2C42 75BB"FEATURE MES_Certification Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0089 5690 BDC9 3249 C0CD AAEC E4F4 \1100 74BC 6F92 E696 CC73 5B1C 86BD 8346"FEATURE MES_Data_Editor_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=1 HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00DE 0614 CE77 D6AF 669F B1D7 \D599 CA00 49EF 2409 D862 6222 7BDE F024 0945"FEATURE MES_Datalog Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00F7 5E21 236C 9791 AAE2 AA97 AA25 \5800 CC2C C1E9 B6AC 0304 8E91 FEC4 C5FC"FEATURE MES_Factory_Connector_Count Wonderware 5.3 14-apr-2021 \ uncounted VENDOR_STRING=64 HOSTID=ANY ISSUER="Invensys \Systems, Inc." NOTICE="Wonderware Demo License File|26561 \RANCHO PKWY SOUTH||LAKE FOREST|California|92630|UNITED \STATES|Not for Resale" SN=2137502-0 TS_OK SIGN="00EA 0583 6BE9 \40DC 022D 5569 F28D 8200 7000 979F EA27 DB9B 42BA D30D 689C" FEATURE MES_Folders Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00D6 A5AE A881 775B AFAD 927E BAFE \DE00 FA84 D6A3 352A DFB9 DAA0 A3FC A8BC"FEATURE MES_Inventory Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0020 8E3B BE44 BAE2 197E 2A26 A980 \C700 2B61 36D7 C8C0 C935 BB3B 6BEC 0607"FEATURE MES_Labor Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00E0 4D44 7677 CD9F AAFD 3D3E 50D1 \E400 C7A0 EBA5 E183 E41F 074D 45C9 1255"FEATURE MES_Operations Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00C7 6DCC 42AC 4866 D71A AF60 BA54 \EA00 9588 102E B6A7 E5FE 9B45 2A9D 8559"FEATURE MES_Operations_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=1000 HOSTID=ANY ISSUER="Invensys Systems, Inc." \ NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="008E 7FEB A65E 5CFC 3CD3 EC24 \ A3BE 3D00 F1D9 FAF6 FBE7 65F0 337B 793C F772"FEATURE MES_Production Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0088 202B 13F1 3350 56F7 A0BB 5078 \8300 A1BA F096 8BE8 46B4 6D62 D3AC F071"FEATURE MES_Quality Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00D4 A9BA 5CD5 66E7 BF42 2BC5 4F10 \F800 22AE 5392 FAA0 FDE2 8118 8705 D9DF"FEATURE MES_Quality_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=1000 HOSTID=ANY ISSUER="Invensys Systems, Inc." \ NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="001C 56E6 422C C97B 2D33 8597 \ 37F1 5A00 56DC 9B60 6E5A CC8E C1AD 6CEB 6384"FEATURE MES_Quality_Spec_Count Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00E4 A4A3 25F0 55ED 721A 819D CD23 \4900 B905 B8FE DB14 A9E8 F9E4 8463 2BC0"FEATURE MES_Session_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=-99 HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00FA 3F47 5371 0E94 8ECE 9648 \ B887 3A00 80E2 FE91 C4DE 6521 6E5D 0EC9 0D4D"FEATURE MES_Shipping Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00CC AB65 FAF4 1052 5B42 D8D9 7B5F \DE00 891C B2A7 DC45 485B 5796 47D3 ECB0"FEATURE MES_Specifications Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="0072 7939 7840 3313 95F9 0A9E C4AC \9B00 C961 2895 A94D B587 63E3 D6F8 D08B"FEATURE MES_Steps Wonderware 5.3 14-apr-2021 uncounted HOSTID=ANY \ ISSUER="Invensys Systems, Inc." NOTICE="Wonderware Demo \License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00F0 416F 4C97 3F4D B090 C538 03E5 \7D00 5702 2C2B C9FB 2E83 24F2 C3DD 2BD9"FEATURE MES_Storage_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=200000 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0054 55B3 D0A7 BD10 C3B9 5D06 \ 0E82 3E00 F666 B1F2 9456 58B8 005A 7445 C70A"FEATURE MES_Supply_Chain_Connector Wonderware 5.3 14-apr-2021 \ uncounted HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="009F 3BEA 2B56 E4EE 82AC EA49 \189B 9600 12A9 F883 F8EA 926A 7763 D9C0 662C"FEATURE MES_Utilization Wonderware 5.3 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="006B AC00 7A33 1216 FA61 5396 22B0 \4A00 79CF 7171 FB49 B710 4F7A 5860 09D1"FEATURE MES_Utilization_Count Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=1000 HOSTID=ANY ISSUER="Invensys Systems, Inc." \NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00E4 FE88 34A2 D76D 960D E8C0 \ 3738 A900 09B2 1CB9 9E45 B937 F22D 47C7 09BE"FEATURE MXAccess_Runtime Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00C9 26CB B7F1 F9D2 1C41 C5D0 \ 8EED C300 4AD0 9258 242B 1F70 386F 713B 53F6"FEATURE OI_Server Wonderware 11.1 14-apr-2021 uncounted \VENDOR_STRING=count:2 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00DC 197F 518E E248 8BFD 0444 \ 0FDC 5100 67DA 2ADE CFC8 E8AD A10C EFF8 3A61"FEATURE Platform_Count Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:100 HOSTID=ANY ISSUER="Invensys Systems, \ Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="0056 8394 5F2A CE55 568A 0EBD \ B562 4700 855F BD8F 91E7 F7C4 1B91 185D 889E"FEATURE Quick_Reports Wonderware 4.1 14-apr-2021 uncounted \ VENDOR_STRING=count:10000 HOSTID=ANY ISSUER="Invensys Systems, \ Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="009C FF2B F257 5284 375D EAF1 \ 9133 C500 EBA3 5047 27EB A744 AA54 5A12 EF4E"FEATURE SPCPro Wonderware 10.6 14-apr-2021 uncounted \VENDOR_STRING=count:1 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \Resale" SN=2137502-0 TS_OK SIGN="00F0 6C4E 8D91 5AEA 717E F12E \ 34FC 0900 6F2D F401 6D7A 96CD CBCB 9210 812E"FEATURE SVoyager_Portal Wonderware 17.0 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 TS_OK SIGN="00D4 2E45 627B 6B51 C4ED 6D41 8A50 \BD00 0245 8BD6 7E56 8C04 BEC4 5097 93E2"FEATURE SVoyager_WriteEnable Wonderware 17.0 14-apr-2021 uncounted \ HOSTID=ANY ISSUER="Invensys Systems, Inc." NOTICE="Wonderware \Demo License File|26561 RANCHO PKWY SOUTH||LAKE \FOREST|California|92630|UNITED STATES|Not for Resale" \SN=2137502-0 SIGN="00E7 6371 80D6 B15B F03F BCF7 DF6E 9300 \4E43 ED40 C554 C4DC 489B F557 7022"FEATURE WEI_Professional Wonderware 5.3 14-apr-2021 uncounted \ VENDOR_STRING=count:0 HOSTID=ANY ISSUER="Invensys Systems, \Inc." NOTICE="Wonderware Demo License File|26561 RANCHO PKWY \ SOUTH||LAKE FOREST|California|92630|UNITED STATES|Not for \。
解决wind ows2008 r2 64位支持access数据库问题因为微软要放弃access了,所以就没开发access数据库64位的.如果你的win7是64位,同样也不能支持access.说到这里其实大家就知道为啥64位windows2008 R2 版本不支持access原因了.因为access 只有32位,但windows2008 r2 64位默认程序都是64位的.解决方法:打开IIS管理器,查看网站的高级属性应用程序池选项,记住当前使用的应用程序池名称。
也可以在这里直接修改使用的应用程序池。
强调一下,无论使用哪个应用程序池都是可以成功启用Access的------------------------------------------------------------------------------------------------------返回,点击左边应用程序池节点,查看刚才使用的应用程序池的高级属性(这里是DafaultAppPool)启用32位应用程序选项设为TrueIIS的设置到此结束接下来修改一些access临时要用的文件夹访问权限C:\Windows\temp (典型路径,请根据实际安装路径确定)Users的可读写权限C:\Windows\ServiceProfiles\NetworkService\AppDataLocal\Temp给上面两个文件夹添加Users的可读写权限如果还不足够,继续给C:\Inetpub\wwwroot\App_Data添加Users的可读写权限ADODB.Connection 错误'800a0e78'对象关闭时,不允许操作。
/cepluslyc04/remote_soft.asp,行1360出现这个错误可以尝试C:\Windows\temp (典型路径,请根据实际安装路径确定)Users 的可读写权限这个方法,亲测!。
Windows7(64位)成功连接Access2003一、在Windows7(64位)下,C#成功使用Access2003下载:AccessDatabaseEngine_X64.exe(64位数据库引擎ADE)/zh-cn/download/details.aspx?id=13255(1)在Windows7(64位)下,卸掉 office2003或2007,不卸掉64位数据库引擎ADE 不能安装;(2)先安装AccessDatabaseEngine_X64.exe;其次安装Office2003或Office2007;(3)开发项目中引入System.DATA。
其中有System.Data.OleDb ;(4)将程序语句中“Microsoft.Jet.OLEDB.4.0”改为“Microsoft.ACE.OLEDB.12.0”即可。
见代码如下: //WindowsXP 连接Access2003//string strCN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="文件名";Jet OLEDB:Database Password=密码"; // Windows7(64位)/ Windows XP 连接Access2007或2003 Connection string for via OleDBstringstrCN = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" 文件名 ";Jet OLEDB:Database Password=密码"; try {cnDB = new OleDbConnection (strCN);cnDB.Open();return cnDB;//返回类型为OleDbConnection 类} catch (Exception ex) {MessageBox .Show(ex.Message);return null ;}即ACE 与操作系统、数据库和应用程序的匹配关系,见下图:图1. ACE 与操作系统、数据库和应用程序的匹配关系安装AccessDatabaseEngine_X64.exe (64位数据库引擎ADE)即一系列组件,帮助在现有的 Microsoft Office 文件(例如 Microsoft Office Access 2010(*.mdb 和 *.accdb )和 Microsoft Office Excel 2010(*.xls 、*.xlsx 和 *.xlsb )文件)与其他数据源(例如 Microsoft SQL Server )之间传输数据。
如何配置InTouch Access AnywhereInTouch® Access Anywhere 是 InTouch 最近添加的一项功能,它是一项 InTouch 扩展功能,可用于通过兼容 HTML5 的 web 浏览器访问 InTouch 应用程序,而无需安装任何客户端软件,此外,它还支持用户随时随地通过任何设备以安全的方式对工厂设备进行故障排除。
InTouch® Access Anywhere借助了微软的Remote Desktop Services,因此需要在安装InTouch® Access Anywhere前先启用Remote Desktop Services并进行RDS授权安装。
启用Remote Desktop Services必须是Windows Server版本操作系统,下面以Windows Server 2008R2系统举例:由于Remote Desktop Services在没有授权的情况下可以临时使用120天,因此选择为以后配置。
添加用户或组到本地Remote Desktop Users中,默认添加了administrators组。
如浏览器登录时输入的用户不属于administrators组,请添加该用户至本地Remote Desktop Users 中。
重启计算机进行配置添加安装成功后,如没有使用Remote Desktop Services授权,在每次重启操作系统时会提示剩余的免费使用天数。
InTouch® Access Anywhere允许多用户同时连接远程桌面会话主机,因此需要取消“限制每个用户只能进行一个会话”的限制。
InTouch® Access Anywhere的客户端在登陆至主机后会生成一个连接会话,我们可以配置空闲会话限制等,使得连接会话能够有效的释放。
到这里,Remote Desktop Services已经配置完成,我们可以通过使用远程桌面的方式来测试Remote Desktop Services是否正常运行,建议测试多台计算机同时使用一个用户名远程的方式。
解决Win7上的连接acc ess数据库的问题最近做了一个w i n桌面程序,没有用sql数据库,而是用acce ss数据库,因为acces s比sql用起来方便多了,最主要是不要安装sql server,直接放在程序里面,然后创建连接字符就可以了,sql语句大部分相同。
软件做完后,不能在win7上跑起来,只要运行软件就报这样错在“宇内流云”的指导下,这个问题终于解决了,在些特别感谢“宇内流云”。
下面简单说一下方法一1、把msjetoledb40.dll文件解压放到wind ows\system32中。
2、开始--->运行,输入regsvr32 msjetol edb40.dll,回车。
这样就可以了,方法二:我是按照《未在本地计算机上注册“Microso ft.Jet.OLEDB.4.0”提供程序》博文操作的来自:/lemonte c/article/details/1754413简单的程序代码如下:DataSet ds=new DataSet();try{stringstrCon= @"Provide r=Microso ft.Jet.OLEDB.4.0;Data Source=E:/test.xls;Extende d Propert ies='ExcelOleDbCo nnecti on oleCon= new OleDbCo nnecti on(strCon);oleCon.Open();OleDbDa taAdap ter oleDA = new OleDbDa taAdap ter("select* from [sheet$]", oleCon);oleDA.Fill(ds);}catch (Excepti on ex){Message Box.Show(ex.Message + ex.Source+ ex.InnerEx ceptio n);}报错:未在本地计算机上注册“Microso ft.Jet.OLEDB.4.0”提供程序。
InTouch与关系数据库的数据交互这是由Wonderware 中国的技术支持写的有关Wonderware产品的技术信息,供中国地区的分销商,系统集成商以及最终用户参考。
此技术信息并不包括在Wonderware公司提供的KBCD中,但使用者应参看Wonderware公司KBCD中的Terms of Use,获取并保证接受其规定的使用者应遵守的相关约定。
文档号:CNTN-IT-001制作:2006年8月概要介绍这篇文章描述了Wonderware InTouch软件如何读、写关系数据库数据的步骤。
本文以Mi crosoft Access 2000/2003为例,描述了Wonderware InTouch 通过ODBC或OLE DB接口和Access进行数据交互的具体步骤。
在实际应用中,Wonderware InTouch软件可通过类似步骤实现与其他关系数据库的数据交互,如Oracl e、SQL Server等。
此文档通过InTouch SQL访问管理器将Wonderware ®InTouch™ 的数据记录到关系数据库中;从关系数据库中读出数据到InTouch的方法类似。
详细的函数使用方法请参考《Intouch SQL Access Manager 用户手册》。
在开始之前,请确保已满足以下条件:1. 安装InTouch及其最新补丁,本文使用InTouch 9.5中文版。
2. 确保在安装InTouch时选择了安装―SQL Access Manager‖选项。
3. 安装Mi crosoft Office XP/2003 专业版并确保安装了Microsoft Access选项。
本文使用Mi crosoftAccess 2003。
创建Microsoft Access数据库并配置ODBC数据源创建Access演示数据库,并配置相应的ODBC数据源。
注:如果采用OLE DB数据接口,可忽略下面配置ODBC数据源的步骤(第二步)。
使用InTouch的SQL Access把数据记录到Microsoft(MS)Access 数据库摘要本文详细的描述了如何配置Micsoft Access 2000 ODBC数据源名称(DSN)及如何使用InTouch当中的SQL Access把数据记录到Microsoft(MS)Access 数据库当中。
本文包含的图片是从Window200 Server计算机上被抓取的。
如果你使用的不是该操作系统,图片会和本文中的不一样。
术语在你开始阅读以下程序之前,请先自己熟悉一些术语及它们的定义,本文中将会使用到它们:为Microsoft Access配置SQL 访问下面的几步展示了如何为Microsoft Access配置SQL访问。
1.启动MS Access.a.创建新的数据库表或使用一个现存的数据库表.b.记下数据库文件名(举例: SQLAccessData.mdb), 表名和字段,字段的数据类型,字段尺寸这些都会在以后用到。
2.如果你还没有在Intouch中安装SQL ,就安装SQL Access Manager3.如果有必要, 安装MS Access 2000 ODBC驱动a.启动ODBC Data Source Administrator.b.选择开始, 程序,管理工具,数据源(ODBC).o ODBC Data Source Administrator 对话框显示如下(表1).表1: The ODBC Data Source Administrator对话框c.在ODBC Data Source Administrator对话框, 点击Add按钮建立一个新的数据源。
o“Create New Data Source”对话框如(表2) 显示o修改一个现存MS Access Data源,可以点击表1中的“Configure”按钮表2: The Create New Data Source 对话框d.一旦指定了一个新的或已存的数据源,ODBC Microsoft Access 安装对话框将出现(表3)表3: The ODBC Microsoft Access 安装对话框e.键入DSN名称(例如: SQLAM_Access),然后点Select按钮o将显示选择数据库对话框(表4)f.指定一个MS ACESS数据库(例: C:\Intouch Applications\SQLAccessTest\Test.MDB).g.点击确定按钮.表4: 选择数据库对话框o数据库选择后, 数据库将显示在ODBC Microsoft Access安装对话框中(表5).表5: 选择数据库对话框-数据库选择4.创建一个InTouch的应用程序,其中的标记名和MS Access数据库中的列名相同。
标题:Intouch2014 R2在win7-64位专业版系统和MS Access数据库的数据交互
版本:V1.0
测试环境:Intouch2014 R2软件,开发板+运行版授权,win7-64位专业版系统,ModBustest,MS Access 2003,无硬件
编写时间:2020-03
部门:交付运维中心
目录
1,首先建立MICROSOFT OFFICE ACCESS2003数据库 (3)
2,ACCESS数据表字段绑定INTOUCH标签名 (4)
3,编写脚本 (5)
4,运行效果 (8)
1,首先建立Microsoft Office Access2003数据库
新建Access数据库,并命名为Access1,新建一个Access数据表,也命名为Access1(这个表名后边写脚本的时候需要用到),在设计视图下,添加字段名并选择数据类型。
备注:这里我安装的是MS Access2007,所以需要先新建一个Access 2007(.accdb),在另存为Access 2003(.mdb)文件,
2,Access数据表字段绑定Intouch标签名
使用特殊—SQL访问管理器—绑定列表,进行Access数据表字段名和Intouch标签名的绑定,
如下图:此处的绑定列表名“HSdata”后边编写脚本的时候需要用
3,编写脚本
大体上分为3个步骤,连接数据库,插入数据,断开数据库。
Step1:做3个按钮,2个文本
Step2:连接数据库按钮,左键动作脚本如下:
Resultcode=SQLConnect( ConnectionId, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Access1.mdb;User ID=;Password=;" );
ErrorMsg=SQLErrorMsg( Resultcode );
其中,“Resultcode”“ConnectionId”“ ErrorMsg”是标记名,”SQLConnect ”“ SQLErrorMsg”是函数,Data Source=C:\Access1.mdb,是第1步骤新建的access 数据库路径全名。
Step3:插入数据按钮,左键动作脚本如下:
Resultcode=SQLInsert( ConnectionId, "Access1", "HSdata" );
ErrorMsg=SQLErrorMsg( Resultcode );
其中,“SQLInsert”是SQL函数,"Access1", "HSdata"分别是第1步骤里的access 数据库表名,第2步骤里的绑定列表名。
Step4:断开数据库按钮,左键动作脚本如下:
Resultcode=SQLDisconnect( ConnectionId );
ErrorMsg=SQLErrorMsg( Resultcode );
其中,“SQLDisconnect”是SQL函数。
4,运行效果
假设这里已经建立了4个标记名为TAG1,TAG2,TAG4,TAG5,并且用Modbus模拟器进行模拟得到数据。
Step1:点击“连接数据库”按钮,可以看到Intouch画面上的SQL状态和错误信息是正常的;Access数据库路径下多了一个同名1KB大小的文件。
Step2:点击“插入数据”按钮2次,可以看到SQL状态正常。
Access1数据表中,被插入了2行数据。
Step3:点击“断开数据库”按钮,可以看到SQL状态正常,本章step1中连接时Access路径下生成的同名1KB文件消失了。