SA801F 220VAC
SA801F 220VAC
SA801F 220VAC
SA801F 220VAC
選擇一種客戶/月艮務(wù)器體系結(jié)構(gòu)的數(shù)據(jù)庫軟件，分別安裝在客戶端和服務(wù)器端。
2)連接數(shù)據(jù)庫：
應(yīng)用程序是通過“連接”訪問數(shù)據(jù)源，連接是交換數(shù)據(jù)所必需的環(huán)境。所以，創(chuàng)建“Connection”對象是所有數(shù)據(jù)庫操作的必需的第一步驟。
3)執(zhí)行SQL指令：
通過已經(jīng)建立的連接發(fā)出的SQL指令可以用某種方式來操作數(shù)據(jù)源。Microsoft ADO的Com mand對象，Connection對象以及Recordset對象都提供有執(zhí)行SQL指令的方法，依據(jù)具體情況具體選擇對象。
4)處理結(jié)果：
檢索到的數(shù)據(jù)有需要加以處理的則通過各種需要的算法加以處理。
5)關(guān)閉連接：
執(zhí)行完任務(wù)后，必需切斷與數(shù)據(jù)庫資源的連接，釋放任何屬于連接的資源，關(guān)閉任何從屬對象，因?yàn)樗褂昧朔?wù)器的資源，如果不釋放的話將導(dǎo)致服務(wù)器資源浪費(fèi)并影響服務(wù)器性能[3]。
Oracle是以高級結(jié)構(gòu)化查詢語言(SQL)為基礎(chǔ)的大型關(guān)系數(shù)據(jù)庫，通俗地講它是用方便邏輯管理的語言操縱大量有規(guī)律數(shù)據(jù)的集合，是目前最流行的客戶/服務(wù)器(CLIENT/SERVER)體系結(jié)構(gòu)的數(shù)據(jù)庫之一，也是目前技術(shù)比較領(lǐng)先、應(yīng)用非常廣泛的一個(gè)商業(yè)數(shù)據(jù)庫產(chǎn)品。所以我們選擇Oracle來搭建所需的網(wǎng)絡(luò)數(shù)據(jù)庫。數(shù)據(jù)庫管理大部分是對數(shù)據(jù)的查詢、插入、修改和刪除等操作的綜合應(yīng)用。
在運(yùn)行LabVIEW程序的應(yīng)用程序服務(wù)器上，假設(shè)已經(jīng)安裝了Oracle客戶端，并連接數(shù)據(jù)庫服務(wù)器上的遠(yuǎn)程數(shù)據(jù)庫成功，通過Windows控制面板中管理工具里面的“數(shù)據(jù)源(ODBC)”來創(chuàng)建 ODBC數(shù)據(jù)源，設(shè)置系統(tǒng)DSN(數(shù)據(jù)源名稱)為loginoracle，驅(qū)動程序選擇Microsoft ODBC for Oracle。設(shè)置成功后我們就可以像訪問本地?cái)?shù)據(jù)庫一樣訪問遠(yuǎn)程數(shù)據(jù)庫了。
3 應(yīng)用實(shí)例
以下，我們就結(jié)合一個(gè)具體的應(yīng)用實(shí)例說明如何在LabVIEW環(huán)境中實(shí)現(xiàn)對遠(yuǎn)程Oracle數(shù)據(jù)庫的訪問。
我們建立了一個(gè)校園網(wǎng)虛擬實(shí)驗(yàn)室，將我?？刂葡档倪^程控制實(shí)驗(yàn)室的液位過程控制實(shí)驗(yàn)搬到了網(wǎng)站上，學(xué)生和老師在宿舍就可以遠(yuǎn)程監(jiān)視并控制其運(yùn)行狀態(tài)，但是實(shí)驗(yàn)裝置并不是隨時(shí)打開的，我們需要將它的歷史狀態(tài)保存在數(shù)據(jù)庫中，以便在未打開裝置的情況下通過歷史數(shù)據(jù)顯示數(shù)據(jù)采集曲線，因此我們在數(shù)據(jù)庫服務(wù)器上建了一個(gè)Wave-b表，將液位高度數(shù)據(jù)和控制器輸出電壓數(shù)據(jù)保存在其中，我們就對這個(gè)表進(jìn)行相關(guān)的操作。
INDRAMAT SERVO MOTOR MAC112D-0-ED-4-C Used
Indramat Servo Motor~MDD065B-N-040-N2L-095GA0~Rebuilt
REXROTH INDRAMAT SERVO-MOTOR MDD115A-N-030-N2M-130GA1
INDRAMAT MDD071B-N-040-N2M-095PB1 MAGNET MOTOR *NEW
Indramat Servo Drive HDS04.2-W200N-HS45-01-FW CNC
INDRAMAT MDD093B-N-020-N2L-110PA0 PERMANET MAGNET MOTOR
REXROTH INDRAMAT DKC02.3-040-7-FW NEW DKC0230407FW
Indramat Rexroth 237117 Permanent Magnet Servo Motor
INDRAMAT MAC112D-0-HD-2C/130-A-0/S05 SERVO MOTOR
Indramat Digital AC Servo Drive DDS02 1-W050-D 50 AMP
BOSCH REXROTH INDRAMAT SERVO MOTOR MKD090B-35-KP0-KN
Indramat Servo Motor Part MDD112C-N-030-N2M-130GB1 Used
Indramat MDD071B-N-040-N2S-095GA1 Servo Motor New NOS
Indramat Servo Motor MHD090B-035-PP0-UN
INDRAMAT MAC112B-0-GD-1B/130-A-0/I1250/S005 SERVO MOTOR
INDRAMAT (MAC090-0-GD-2-C/110B-0/S001) SERVO MOTOR !!!
Indramat MDD065B-N-040-N2L-095PB1 Servo Motor Rebuilt
INDRAMAT MAC 112D-2-HD-4-C/130-A-0/WI520LV/S005 MOTOR
Indramat Magnet Servo Motor MDD093C-N-030-N2L-110GA0
Indramat Magnet Servo Motor MDD090C-N-030-N2M-130PB0
REXROTH INDRAMAT SERVO-MOTOR MDD093C-N-030-N2L-110GA2
Indramat Magnet Servo Motor MDD090C-N-040-N2M-110GA1
REXROTH INDRAMAT SERVO MDD115A-N-030-N2M-130GA1 REMAN
INDRAMAT PERMANENT MAGNET MOTOR MKD041B-144-GP0-KN
Indramat Servo Motor 2AD100B B050B1-ASO3-B2N1
Indramat Servo Drive HDS02.2-W040N-HS32-01-FW CNC
Indramat MDD071C-N-030-N2S-095PB0 Servo Motor
Rexroth Indramat MHD093C-035-PG1-AA Servo Motor
INDRAMAT INDUCTION SERVO MOTOR 2AD160B-B050B1-BS03-B2N1
INDRAMAT AC SERVO CONTROLLER TDM 3.2-030-300-W1
INDRAMAT MDD071B-N-040-N2M-095PB1 MAGNET MOTOR *NEW
Indramat Servo Motor - MDD071C-N-060-N2G-095GB0
Indramat Servo Motor MDD112C-N-040-N2M-130GB2 11265317
INDRAMAT BRUSHLESS SERVO MOTOR 1120-N-030-N2L-130PB2
Rexroth Indramat MHD041B-144-PPO-UN - Servo Motor
Indramat Magnet Servo Motor MDD090C-N-030-N2M-110GB0
Indramat Magnet Servo Motor MDD090C-N-030-N2M-110GB0
MDD093C-N-030-N2L-110GA0 INDRAMAT SERVO*1YR.WRTY*
REXROTH INDRAMAT PPC-RO2.2N-N-V2-NN-NN-FW USED PPCR022N
INDRAMAT DRIVE DKC01.3-100-7-FW
Indramat Servo Motor MAC 071C-0-JS-4-C1095-A-2/MR136
INDRAMAT DDC01.2-N200A-DS68-00-FW *RECONDITIONED*
REXROTH INDRAMAT PERMANENT MAGNET DC MOTOR SERVO
MAC071C-0-GS-2-C/095-B-0/S01 INDRAMAT-WEEKE SERVO*1YR.W
Indramat DKC02.3-040-7-FW AC Controller - Excellent !!
Indramat Servo Motor 2AD 100B _ 2AD100B B050B1-ASO1-S01
Indramat Servo Drive HDS04.2-W200N-HS32-01-FW CNC
INDRAMAT MDD093B-N-020-N2L-110GA0 PERMANET MAGNET MOTOR
Indramat MAC112B-0-GG-3-F/130-B-1 Motor
Indramat Servo Drive HDS04.2-W200N HDS042W200N CNC
MAC071C-0-GS-3-C-095-B-0-S001 INDRAMAT-WEEKE
Indramat Rexroth 263991 Permanent Magnet Servo Motor
INDRAMAT MDD071B-N-030-N2L-095PB0 PERMANET MAGNET MOTOR
INDRAMAT MDD093B-N-020-N2L-110PA0 PERMANET MAGNET MOTOR
Rexroth Indramat RME02.2-32-DC024, Input Module NEW
Indramat Servo Drive & Servo Motor
INDRAMAT HDS AC SERVO DRIVE HDS03.2-W075N NEW with box
BOSCH REXROTH INDRAMAT SERCOS FIBER OPTIC PATCH CABLE
REXROTH INDRAMAT INK0572 STYLE 20668 SERVO CABLE
DDS02.1-W150-D INDRAMAT
INDRAMAT GDS1.1 GDS01.1 GDS011 DDS SERCOS OPTION BOARD
Indramat AC Servo Controller TDM1-100-300-W1
INDRAMAT TVD1.2-08-03
NAM1.2-08 INDRAMAT LINEFORMER
INDRAMAT RAC 3 AC SPINDLE DIRVE RAC3.5-150-460 TESTED
REFURB REXROTH INDRAMAT HDD02.2-W040N-HD32-01
REXROTH INDRAMAT SERVO DRIVE HDS HDS03.2-W075N
Indramat DKS1.1W100A-D Digital Servo Control
DSS 1.1 INDRAMAT
DAE1.1 INDRAMAT
Indramat Multi-Axis Coordinate Motion Card CLC-D-2.1-A
INDRAMAT DDC01.1-K150A-D AC DIGITAL CONTROLLER
KDV1.1-100-220/300-220 INDRAMAT 1 YR. WRTY
INDRAMAT 03-0721 Servo Motor Cable ! WOW !
INDRAMAT DPF05.1 PROFIBUS INTERFACE PLUG-IN MODULE
BOSCH REXROTH INDRAMAT SERCOS FIBER OPTIC PATCH CABLE
INDRAMAT NAM 1.3-08 AC. SERVO LINE FORMER AC SERVO
TVD1.2-15-03 INDRAMAT SERVO POWER SUPPLY
Indramat AC Servo Power Supply TVM 2.4-050-220/300-W1
INDRAMAT DEA5.2/DEA05.2 I/O INTERFACE PLUG-IN MODULE
INDRAMAT DFF1.1 ENCODER INTERFACE PLUG-IN MODULE*XLNT*
INDRAMAT AC SERVO CONTROLLER TDM2.1-30-300-W0
DSS 1.3 INDRAMAT
Indramat DKS01.1-W100A-D Digital AC Servo Compact Contr
Rexroth Indramat Servo Drive Controller TDM3020300W0
INDRAMAT DSS1.3/DSS01.3/DSS31/DSS031 SERCOS MODULE*XLNT
INDRAMAT DKS01.1-W100A-D DKS DKS1.1 DKS 1.1 REMAN
Indramat AC Servo Controller TDM 1.4-050-300-W1
Indramat NAM1.2-15 AC Servo line Former NAM 1.2-15
/REFURB REXROTH INDRAMAT DDS2.1W-100 SERVO DRIVE
Indramat Servodrive MAC 112C-1-HD-3-C/130-A-0 !
INDRAMAT HGV ENCODER JUNCTION S/N 234901-00772 A01 XLNT
Indramat DEA 4.2 I/O Digital Interface Card DEA04.2
Indramat AC Servo Line Former NAM 1.3-15 #11229
Indramat HZK02.1 Capacitor Module HZK02.1-W003N **New*
INDRAMAT TVM1.2-050-W0-220V DRIVE
Indramat BZM01.3-01-07 bleeder module
INDRAMAT POWER SUPPLY TUM 2.1-50-220/300-W1-115/220
Indramat TDM 1.2-30-300-W0 AC Servo Controller Rexroth
Indramat TVM 2.1-50-220/300-W1-115/220
INDRAMAT DKS01.1-W050A-DL01-01-FW
INDRAMAT 5 M CABLE 11610150
INDRAMAT TDM3.2-030-300-W1 AC SERVO CONTROLLER NEW
Rexroth Indramat Style 20233, Servo Cable
BGR-NTB-02-00 INDRAMAT POWER SUPPLY BOARD
Rexroth Indramat HVR02.2-W025N AC Controller *Tested*
INDRAMAT HDS AC SERVO DRIVE HDS02.2-W040N REMAN
Indramat DDS2.1-W050-D AC Servo Controller Rexroth
INDRAMAT NAM 1.2-15 AC SERVO LINE FORMER MODULE
TVM-2.1-50-W1-220V INDRAMAT
BOSCH REXROTH INDRAMAT ECODRIVE DKC...200 PLASTIC COVER
BOSCH REXROTH INDRAMAT ECODRIVE DKC...100 PLASTIC COVER
TVD1.2-08-03 INDRAMAT
Indramat AC Servo controller TDM 3.2-030-300-W1
INDRAMAT NAM 1.3-15 LINE FORMER MODULE ..NEW!!
Indramat Rac2.3-200-460-A0D-W1 Main AC Spindle Drive
Indramat HDS03.2 AC Controller HDS03.2-W075N-HS32-01-FW
REFURB REXROTH INDRAMAT HDS03.2-W075N-HS12-01-FW
INDRAMAT DDS02.1-W050-DA02-01-FW SERVO CONTROLLER NEW
TVM2.1-50-220-300-W1 INDRAMAT POWER SUPPLY
INDRAMAT POWER SUPPLY TVM2.2-050-220/300-W1/220/380
TVM2.1-50-220/300-W1-115/220 INDRAMAT *1YR.WRTY*
BOSCH REXROTH INDRAMAT ECODRIVE 03 - DKC06.3 INPUT CARD
Indramat AC Servo P.S. TVM 2.4-050-220/300-W1/115/220
INDRAMAT SERVO P/S LINE FORMER NAM1.2-08 **XLNT**
BOSCH REXROTH INDRAMAT ECODRIVE DKC...040 PLASTIC COVER
Rexroth Indramat RMB02.2-04, pn: 278846 Base plate NEW
Indramat Firmware Module Card DSM02.1-FW
TVM-2.4-050-220-300-W1-115-220 INDRAMAT POWER SUPPLY **
Indramat AC Servo Controller DDS 2.1-W150-D Rebuilt
INDRAMAT IKO982/0.25 SERCOS FIBER OPTIC CABLE**XLNT**
KDV1.2-100-220/300-115 INDRAMAT
INDRAMAT TVD1.3-15-03
Indramat NFD02.1-480-008 Servo Power Filter NEW
TVM2.1-050-W1-115 INDRAMAT
TVD1.3-08-03 INDRAMAT POWER SUPPLY **1YR. WRTY
INDRAMAT TVD1.2-15-03
Indramat Servo Power Supply TVM12050220300W0
Indramat Servo Motor MDC-10.30D/MM-0 Permanent Magnet
INDRAMAT AC SERVO DRIVE DDS02.1-W050-D 2.1 DDS2.1 NEW
INDRAMAT TVM2.1-50-220-300-W1-115-220 POWER SUPPLY TVM
