User manual
Table Of Contents
- DOP eServer User Manual-cover.pdf
- DELTA_IA-HMI_DOP-eServer_UM_EN_20140707
- Table of Contents
- Publication History
- Chapter 1 Introduction
- Chapter 2 Software Installation
- Chapter 3 Before using eServer
- Chapter 4 Excel Sampling Setting
- Chapter 5 Writing Data in Microsoft Excel
- Chapter 6 ODBC Sampling Setting
- Chapter 7 Writing Data in Microsoft Access 2003 at XP Operating System
- Chapter 8 Writing Data in Microsoft Access 2007 at Windows 7
- Chapter 9 Writing Data in MySQL
- Chapter 10 Writing Data in SQL Server 2005
- Chapter 11 Writing Data in Oracle
- Chapter 12 Recipe Access Setting
- Chapter 13 Recipe Access Example
- Appendix A Upload & Download via Ethernet
Revision March, 2014 9-1
Chapter 9 Writing Data in MySQL
Before creating testing example, make sure to change the upload and download option
(Options > Environment) on DOPSoft first. The default setting of upload and download is via
USB. If the users need to use Ethernet, please change the default setting by referring to
Appendix A.
9.1 Example
This example is used to help the users to understand how to use eServer to read the data of
the register addresses $3 and $6 every second, record the data in MySQL via ODBC interface,
and save the collected data into the specified folder (C:\Data).
9.1.1 Software Installation
1. AppServ Introduction
AppServ is a free and full-featured software of Apache HTTP Server, MySQL, PHP, and
phpMyAdmin. To download it, go to
http://www.appservnetwork.com.
Package of AppServ
Apache HTTP Server: It is a free and open source HTTP Server.
MySQL: It is a relational database management system.
PHP: It is a free and general-purpose scripting language designed for web
development.
phpMyAdmin: It is web-based open source tool written in PHP for MySQL
database management.
After double clicking the appserv-win32-2.5.10.exe file downloaded from the website
exe file, the following dialog box will appear.