Opticon ESL Server

104 pages

To Next Page

To Previous Page

Opticon ESL

ESL Server manual

v1.0.62.2

Appendix G: DB2 demo configuration

When using DB2, it is mandatory to create an ODBC data source (i.e. called DB2_ODBC_ESL) to

connect to the DB2 database. See chapter 7.3 for more information on ODBC.

Use the following configuration in the ESL server.

After making the configuration, use the ‘Test’-button to test the connection details.

Main Page

Default Chapter2
- Document History2
- Serial Number2
- Table of Contents3
1 Features and Specifications6
- Abstract6
- Contents of an ESL Demo Kit6
- Physical Features6
  - Dimensions6
  - Weight6
- Environmental Specifications7
  - Operating Temperature and Humidity (EE201)7
  - Storage Temperature and Humidity (EE201)7
- Interface Specifications7
- Electrical Specifications7
  - Electrical Characteristics7
  - Main Batteries8
- Hardware Specifications9
- Serial Number10
  - Ebs-31 / Ebs-4010
  - Esls10
- Safety10
2 Solution Overview11
- CSV-File Based Solution12
- SQL Solution13
- CSV / SQL Hybrid Solution14
- External Content Management Solution14
- Sql Api14
3 Setting up the Hardware and Software15
- Installing the ESL Server Application15
- Installing and Finding the Ebs3X / EBS40 Base Stations15
- Installing and Activating the Esls16
- Mounting Esls17
4 Linking of Esls to Products18
- Linking in the ESL Server Application19
- Linking Using an Opticon Batch Terminal20
- Linking Using the Provided Web Application20
5 Configuring the Base Stations21
- Configuring the RF Channel21
- Changing the Local Name22
- Changing the PAN ID / LAN ID22
- Configuring the Ethernet Settings23
- Factory Default24
- Base Station Firmware Update25
  - Trouble Shooting25
6 Configuration and Monitoring of Esls26
- Configuration of Esls26
- Monitoring of Esls29
- Filtering Esls30
- Controlling Esls30
7 Database Configuration32
- CSV Data Base Configuration33
  - Changing the Database Format and Settings34
- SQL Data Base Configuration36
- Open Database Connectivity (ODBC) Configuration52
- CSV / SQL Hybrid Configuration54
- External Content Management Configuration56
- Manual Editing of the Product Database58
- Editing the Links-Table58
8 Designing the ESL Image Layout59
- Template Selection60
  - Conditions61
- Using the Template Editor63
  - Static and Dynamic Content65
  - Conditional Objects65
- Saving and Exporting a Template66
- Using Example Data66
9 Connecting the Back Office Using CSV-Files68
- Product Database Format68
- Product-ESL Link Database Format69
- Middleware Application (CSV-Files Only)71
10 Barcode Terminal Application72
- Setting up the Barcode Terminal72
- Loading the Database Files on the Terminal73
- Creating Links between Esls and Products73
  - Oph100X, H13, OPH3000 or OPL972874
  - Opn2002/3/4/5/675
- Sending the Link File Back to the PC75
11 Using the Web Application for Linking and Monitoring76
- Web Application with Oracle, Postgresql, Sqlite, MS-SQL and DB278
12 Running the ESL Server as Service78
Appendix A: Demo Barcodes80
Appendix B: My-SQL Demo Configuration81
Appendix C: MS-SQL Demo Configuration83
Appendix D: Oracle Demo Configuration85
Appendix E: Postgresql Demo Configuration87
Appendix F: Sqlite Demo Configuration89
Appendix G: DB2 Demo Configuration91
Appendix H: Restoring the ESL Server Back to Default (CSV)93
Appendix I: Using the SQL API94
Appendix J: Version History99

Opticon ESL Server

Table of Contents