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 10-1
Chapter 10 Writing data in SQL Server 2005
Before giving the example, please setup the upload/download mode for DOPSoft. The
default is【USB】. If desire to change the mode to【Ethernet】, please refer to Appendix A.
10.1 Example
Followings introduce the method for sampling HMI register data, $100, $200 and $300 via
eServer every 5 seconds. Then, save the data in SQL Server 2005 through ODBC interface.
The collected data will be saved in the specified file.
10.1.1 Setup Data Base
Installation of SQL Server 2005 Express:
XP supports SQL Server 2005 Express and SQL Server 2008. Please select SQL Server
2005 Express here. Download SQL Server 2005 Express (SQLEXPR_CHT.EXE is 64 bit
and SQLEXPR32_CHT.EXE is 32 bit) from:
http://www.microsoft.com/downloads/details.aspx?familyid=3181842A-4090-4431-ACDD-9
A1C832E65A6&displaylang=zh-tw
Steps of SQL Server installation: