6ES71555AA000AC0
6ES71555AA000AC0
6ES71555AA000AC0
6ES71555AA000AC0
6ES71555AA000AC0
ODBC是一種用來在相關或不相關的數(shù)據(jù)庫管理系統(tǒng)中存取數(shù)據(jù)的標準應用程序設計接口(API),可以實現(xiàn)不同數(shù)據(jù)庫系統(tǒng)的互連訪問。ODBC是一種使用SQL的程序設計接口，因此，可以使用組態(tài)王的SQL訪問功能實現(xiàn)組態(tài)王和其他ODBC數(shù)據(jù)庫之間的數(shù)據(jù)傳輸。
組態(tài)王與其他外部數(shù)據(jù)庫（支持ODBC訪問接口）進行數(shù)據(jù)傳輸時，首先要在系統(tǒng)ODBC數(shù)據(jù)源中添加數(shù)據(jù)庫，然后通過組態(tài)王SQL訪問管理器和SQL函數(shù)實現(xiàn)各種操作。針對系統(tǒng)高頻記錄、按次存儲與按次查詢的要求，以本系統(tǒng)為例，給出以下具體的解決方案：
（1）建立ODBC數(shù)據(jù)庫
組態(tài)王和其他外部數(shù)據(jù)庫實現(xiàn)數(shù)據(jù)傳輸時必須在系統(tǒng)ODBC數(shù)據(jù)源中定義相應數(shù)據(jù)庫。本系統(tǒng)將Microsoft Access數(shù)據(jù)庫作為組態(tài)王的外部數(shù)據(jù)庫,首先建立一個Access數(shù)據(jù)庫，然后在控制面板下的“ODBC數(shù)據(jù)源(32位)”選項內創(chuàng)建新數(shù)據(jù)源，選擇“Mirosoft Access Driver”。
（2）建立表格模板與記錄體
SQL訪問管理器用來建立數(shù)據(jù)庫列和組態(tài)王變量之間的聯(lián)系。包括表格模板和記錄體兩部分功能。通過表格模板在數(shù)據(jù)庫表中建立表格；通過記錄體建立數(shù)據(jù)庫表格列和組態(tài)王之間的聯(lián)系，表格模板和記錄體都是在工程瀏覽器中建立的。
（3）數(shù)據(jù)以記錄體形式插入數(shù)據(jù)庫
在本系統(tǒng)中，每一個采集周期就有64個監(jiān)測數(shù)據(jù)從采集卡進入計算機,如果將這64個數(shù)據(jù)逐個從內存轉入存儲介質上，系統(tǒng)運行中將頻繁地進行磁盤操作，會降低程序的執(zhí)行效率。由于組態(tài)王允許通過記錄體直接操縱數(shù)據(jù)庫中的數(shù)據(jù)，所以，可以將一個采樣周期的64個數(shù)據(jù)作為一個記錄體，然后由組態(tài)王直接將該記錄體插入數(shù)據(jù)庫內。
ABB ASEA 5735 0001-CN 57350001-CN DSAV-111 DSAV111
ABB Inverter ACS550-01-015A-4 (ACS55001015A4) NIB
ABB 3HAB 2214-1/1 DSQC 315 Module Combination I/O
ABB 3HAB 2214-1/2 DSQC 315 Module Combination I/O
ABB #DSQC-328-3HAB-7229-1 P/C I/O Board 7/3
ABB ACS 500 Variable Freq Drive, 25 hp with cabinet
ABB 1200A MOLDED CASE SWITCH
NEW Abb PC POWER SUPPLY BOARD NPOW42-62c NPOW42
ABB 3E031810 OUTPUT BOARD NEW 3E 031810
ABB DCS500B SDCS-FEX-32 Board
ABB NI0C-01 board for ACS600 drives PN NIOC01, N10C01
ABB ACH550-PDR-04A1-4 3PH 380V 100kA 2HP HVAC
ABB Analog Input IMFEC11 *NEW IN BOX #11150
ABB TBI BAILEY TB417 CONVENTIONAL CONDUCTIVITY TRANSMIT
ABB 3HAC3619-1 X2 Axis Computer Card /
ABB ACS601-0011-2-S00B1200801 208-240VAC 7.5HP * NIB
ABB MSOC/474M14216000 MICROSHIELD O/C
TAYLOR ABB MOD 300 BCKUP MEM MODULE 6014BZ10100
TAYLOR ABB MOD 300 FIELD BUS MODULE 6227BZ10200
New ABB ABB800 APBU-44C Controller Board
ASEA Brown Boveri, ABB DSMB 125
ASEA Brown Boveri, ABB DSMB 125
ASEA Brown Boveri, ABB YTEA 250 -8
ABB YB560101-SV PC Board Monitor #22989
ABB Fischer & Porter Sight Flow Indicator 10E15722HV
New ABB Rectifier 3HAA 3563-AHA/2 #29370
ABB Capacitor C485D40-2LF, 40.0 KVAR #28615
NEW ABB Capacitor C485D40-2LF, 40.0 KVAR #28603
ABB/RANSBURG HV CONTROLLER RDH 611
ABB YB560103 BE/2 DSQC 224 PCB NEW / 1 YEAR WARRANTY
ABB YB-560-103-BE/2 DSQC 224 PC BOARD
ABB 3HAA-3563 ALA/2 DSQC 252 PC BOARD
ABB Disconnect Switch, OETL-NF600ASW, 800A, 690V, New
ALLEN BRADLEY 1326AB-B410G-21-L USPP 1326ABB410G21L
NEW ABB STROMBERG SAFT-163-I0C SAFT163I0C PC BOARD
ABB EHN250C-1 NEW NEMA SIZE 5 3-POLE CONTACTOR
ABB DCS500 SDCS-PIN-11BB Power Board
ABB ACS201-4P1-3-00-10 AC DRIVE ABB ACS 200
ABB 3HAC24241 NEW CONTROL BOARD 3HAC2424-1
ABB 52608317 Photo Amplifier Board Ulma 2020 Stromberg
ABB Drive Control Board M# 58944106 ~NIB SEALED~
ABB Breaker 480V 480 V Type ES ESB43175L 175A 175 A NIB
ABB DSQC-236G YB560103-CD/22 DRIVE BOARD DSQC236G
ABB MODEL PCU-03 PURGE CONTROL BOARD PCU03 NEW
ABB Inverter ACS550-01-015A-4 ( ACS55001015A4 )
ABB Asea Brown Boveri V032 Motor Controller Drive V032
ABB Inverter ACS355-03E-15A6-4 (ACS35503E15A64) NIB
ABB 53MC5412A25BACXDXCXX Controller 53MC5
ABB/Raymond Vacuum-Type Sand Media Blast System A2CPCA
ALLEN BRADLEY 1326AB-B430E-21 USPP 1326ABB430E21
ABB Lighting Contactor 250A A210-30
Allen Bradley 1326AB-B720E-21 1326ABB720E21
NEW ABB A260-30-11-84 Contactor (STR1354)
ABB Robotics Axis Board DSQC236T YB560103-CE/23
ABB Contactor, AF300-30, AF300-30-22-70 New in Box
ABB NIB #A300-30-11-51 IEC 300A 3P 480V CONTACTOR
ABB MODEL DSQC129 YB161102-BV/1 CONVERTER CARD NEW
ABB Robot Teach Pendant S3 - 3HAB 2136 - 1/6
MODICON / ABB COMPACT 984 PLC TRAINING UNIT
ABB Power Distribution Relay CA 290BB93A09
ABB TB82PH2010020 pH / ORP / pION TRANSMITTTER
ABB SERVO DRIVE ACS501-002-4-00P2
ABB S5H ISOMAX Circuit Breaker 400amp E93565 SACES5
ABB, ABB Robot, DSQC 328, 3HAB 7229-1, S4C, S4C+
ABB SR-369 S6N 600A 600V CIRCUIT BREAKER MH527509
ABB Drive Controller Board DSQC 236T
ABB Chopper Control Board 61218289
ABB 7.5kW Inverter Driver ACS401000932 Free Ship
ABB SADT304100R0003 SG3601 9054
ABB MagMaster MM/GEG01003L000E102000000
ABB DSQC 236G YB560103-CD/22 AXIS DRIVE BOARD
ABB DSQC 236G YB560103-CD/24 AXIS DRIVE BOARD
ABB DSQC 236G YB560103-CD/22 AXIS DRIVE BOARD
ABB DSQC 236T YB560103-CE/23 AXIS DRIVE BOARD
ABB DSQC 236T YB560103-CE/23 AXIS DRIVE BOARD
ABB ACH401601122 Adjustable Frequency AC Drive
ABB 57298791 SKT-2 Stromberg serial # 269950
ABB DSQC 3HAA3563-AGA/2 Rectifier Module
ABB Variable frequency Drive 10 HP ACS501-010-4-00P2
ABB Kent-Taylor Fulscope ER/C Chart Recorder Ref
ABB Board Card 5731 0256-DB 57310256-DB DSBC-170
ABB ACS 600 NEW OLD STOCK
ABB MODEL TB84 pH/ORP/pION TRANSMITTER CONTROL UNIT NNB
ABB 63985252d DDCS Branching Unit NDBU-95
ABB GDR Power Supply NGPS-11 MD Kit 6143601
ABB MODEL APSAF-03 SAFETY BOARD 3E-032085 APSAF03 NEW
ABB A145-30-11-84 CONTACTOR AEA
ABB P-HC-BRC-PBA20000 Symphony Processor Bus Adapter
