Advantech ADAM-5560

145 ADAM-5560 Series User Manual

Chapter 5 Network Functions

5.4 SQL Server Function

There is an example for demonstrating how to use the built-in SQL Server function on

ADAM-5560 Series Controller. Please refer to following info.

1. Open “AdvSQLDemo.mwt”.

2. Type to run this example directly.

Contents

Main Copyright Acknowledgements Product Warranty (2 years) Declaration of Conformity Technical Support and Assistance Safety Precaution - Static Electricity Safety Instructions Contents Chapter 1 Overview...............................................1 Chapter 2 Installation..........................................13 Chapter 3 Quick Start......................................... 29 Chapter 4 Modbus Functions............................ 61 Chapter A RS-485 Networks............................. 167 Chapter 5 Network Functions.......................... 123 Chapter 6 Miscellaneous Functions ............... 149 Chapter B Grounding Reference......................173 Chapter C Reference Documents.....................183 Page Page 1.1 Introduction 1.2 Features Page Table 1.1: Programming Languages Table Page Table 1.2: I/O Module Support List Note! For details, refer to ADAM-5000 I/O Module Users Manual. Page 1.3 Specifications 1.3.1 System 1.3.2 USB Ports 1.3.3 VGA Port 1.3.4 Ethernet Ports 1.3.6 RS-485 interface (COM2) 1.3.7 ES-232/485 interface (COM3) (Suitable for touchscreen) 1.3.8 RS-232/485 interface (COM4) 1.3.9 Isolation 1.3.10 Power 1.4 Dimensions 1.5 LED Status 1.6 Limitations Page Page 2.1 Overview 2.2 System Requirements 2.2.1 Host Computer Requirements 2.2.2 ADAM-5560 Series Requirements 2.2.3 I/O Module Requirements 2.3 Hardware Installation 2.3.1 Selecting I/O Module Table 2.1: Discrete and Analog I/O Selection Guidelines Page Page 2.3.2 Selecting Power Supply Module Table 2.2: Power Consumption of ADAM-5000 series (Main Units) Table 2.3: Power Consumption of ADAM-5000 series (IO Modules) 2.3.3 Install Main Unit and Modules 2.3.4 I/O Slots and I/O Channel Numbering Table 2.4: Power Supply Specification Table 2.3.5 Mounting 2.3.6 Jumper and DIP Switch Settings Page 2.3.6.2 DIP Switch Setting Table 2.5: Device ID DIP Switch Table Page 2.4 System Wiring and Connections 2.4.1 Power Supply Wiring 2.4.2 I/O Module Wiring 2.4.3 Connection of Communication Ports 2.4.4 Ethernet Network Connection Page Page Page Page Page Page Page Page Page Page Page Chapter 3 Quick Start 3.3 Multiprog Installation 3.4 Create a Project and Test the System Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Chapter 3 Quick Start 3.5 Special Module Support in KW Page Page 4.1 Introduction 4.2 Modbus/TCP Client Function Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page 4.3 Modbus/RTU Master Function 4.3.1 Modbus/RTU Master Function Example Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Chapter 4 Modbus Functions 4.4 Modbus/TCP Server Functions 4.4.1 Modbus Address Mapping Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page 5.1 Web Server Functions 5.1.1 Configure Web Server Page Page Page Page Page Page Chapter 5 Network Functions 5.2 FTP Server Function Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Chapter 5 Network Functions Page Page 6.1 Advantech Utilities Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page Page A.1 RS-485 Networks A.2 Basic Network Layout Page A.3 Line Termination Chapter A RS-485 Networks A.4 RS-485 Data Flow Control Page B.1 Field Grounding and Shielding Applications B.2 Grounding B.2.1 The Earth for reference B.2.2 The Frame Ground and Grounding Bar Page B.2.5 Single Point Grounding B.3 Shielding B.3.1 Cable Shield Page B.3.2 System Shielding Page B.4 Noise Reduction Techniques B.5 Check Point List Page C.1 Reference Documents C.2 Topics for Getting Familiar with Multiprog Page www.advantech.com