Displaydata 120-0039-05 Networking Device User Manual 601 0009 01

ZBD Displays Ltd Networking Device 601 0009 01

Contents

Manual 2 Installation

Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page i Work Instructions Tesco Basestation Setup Instruction Abstract This document defines the setup to be used for the Tesco Basestation. Prepared by: Shiv Sidar Signed: Date: 11/09/2006 Authorised by: D.Dix Signed: Date: 11/09/2006 Amendment Record Amendment Number Date Amended by Sections / Pages affected 1 11/09/06 S.Sidar Initial Release Document Control The distribution of this document is controlled in accordance with the ZBD Quality management system. The ZBD DCC is the responsible Control Centre. The information disclosed herein is the exclusive property of ZBD Displays Ltd. and is not to be disclosed without the written consent of ZBD Displays Ltd. No part of this publication may be reproduced or transmitted in any form or by any means including electronic storage, reproduction, execution or transmission without the prior written consent of ZBD Displays Ltd. This document is intended for limited circulation. The information contained in this document is subject to change without written notice and should not be construed as a commitment by ZBD Displays Ltd. unless such commitment is expressly given in a covering document. © Copyright ZBD Displays Ltd. (2006)
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page ii TABLE OF CONTENTS 1 INTRODUCTION.....................................................................................................................1 2 APPLICABLE DOCUMENTS...............................................................................................1 3 TESCO BASESTATION SETUP INSTRUCTION........................................................1
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 1 1 INTRODUCTION Below are some notes on how to install the Tesco Basestation. 2 APPLICABLE DOCUMENTS A. BOM – 120-0003-01. 3 TESCO BASESTATION SETUP INSTRUCTION Firstly the following programs below need to be download and installed. MSDE (Rel A) .Net Framework 1.0 – dotnetredist.exe Hot Fix .Net Framework 1.0 SPK 3 EMS – SQL Manager – SQL Manager 2005 for SQL Server Lite Installing .Net Framework 1.0 Double click the executeable file and following the on screen instructions, once completed restart machine. Installing Hot Fix .Net Framework Run the executeable file and follow the on screen instructions and once completed restart machine. Installing MSDE Creating and installing an Instance for both databases – Counters \ ZBDCounters Command: C:\[Location of extracted MSDE]\[ Setup InstanceName=[Name of Instance] SecurityMode=SQL BLANKSAPWD=1 eg. c:\MSDEReIA\Setup InstanceName=Counters SecurityMode=SQL BLANKSAPWD=1 Counters Instance Setup Setup InstanceName=Counters SecurityMode=SQL BLANKSAPWD=1 ZBDCounters Instance Setup Setup InstanceName=ZBDCounters SecurityMode=SQL BLANKSAPWD=1 Configuring Network Access to the database (MSDE) After installing and creating SQL Instances, it is necessary to configure the 'Instance' of the basestation which runs the database. eg. [Basestation name]\[Database name]. This is done with svrnetcn: C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 2 Select the correct instance and enable TCP, as above. This need to be configured on both Instances. Once configured reboot machine. Copy Folders From P:\Customer\Tesco\TescoBasestationInstall Folder Name: ScalesClientInstall Folder Name: ZBDApps To: Local Hard Disk C:\ Using OSQL - Location - c:\Program Files\Microsoft SQL Server\80\tools\binn> From the local machine: type osql -Usa -S(local)\Counters -P or Remotely: type osql -Usa -S([basestation name])\Counters -P Installing database –Tesco Counters From osql, run the following command: >osql >1 Command: restore database dxCountersClient from disk='c:\ScalesClientInstall\TescoCountersDB\dxCountersClient' with move 'dxCountersClient_data' to 'c:\ScalesClientInstall\dxCountersClient_data.mdf', move 'dxCountersClient_log' to 'c:\ScalesClientInstall\dxCountersClient_log.ldf' go Installing database – ZBD Counters From osql run the following command: >osql >1 Command: Restore database TescoCountersDB from disk=’c:\ScalesClientInstall\ZBDCountersDB\TecountersDB.dat go
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 3 Example test command: use dxCountersClient go select count(*) from txProduct go Installing Weighscale S/W Add the 'Message Queueing' component from the Add/Remove components control panel section. Copy TescoCounters folder from c:\ScalesClientInstall directory to c:\Program Files. The following config options may need to be changed: In file "CountersClient.exe.config": <appSettings> <add key="ConfigurationFile" value="CounterConfiguration.xml" /> <add key="scaleattached" value="V" /> <add key="printerenabled" value="N" /> <add key="comport" value="3" /> <add key="baudrate" value="38400" /> <add key="databits" value="8" /> <add key="stopbits" value="0" /> <add key="parity" value="2" /> <add key="flowcontrol" value="0" /> <add key="readtimeout" value="500" /> <add key="printerip" value="192.168.0.1" /> <add key="printerport" value="2001" /> <add key="shutdowncmd" value="shutdown.exe" /> <add key="shutdownprms" value="-s -t 0 -f" /> <add key="restartprms" value="-r -t 0 -f" /> <add key="logfilename" value="c:\CountersLog" /> Check that the following settings have been configured – example as above scale attached = v printer Enabled = N V = Virtual N = None logfilename – change drive letter depending only local drive – eg. d:\Counterlog to c:\Counterlog In file "CounterConfiguration.xml": <appSettings> <add key="SqlXmlConnectionString" value="Provider=SQLOLEDB;data source=(local)\counters;initial catalog=dxCountersClient;uid=sa;pwd=" />
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 4 <add key="SqlConnectionString" value="data source=(local)\counters;initial catalog=dxCountersClient;uid=sa;pwd=" /> Check that both passwords have been set to null. To run the weighscale s/w, run CountersClient.exe ODBC Setup – Tesco Basestation Databases Configure ODBC Data Source – System DSN Click Add – Create New Data Source – Use SQL Server TescoCounters Database Setup – Settings Enter the following details as below Click next >
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 5 Configure the SQL authentication with Login ID – sa and select next > Select the default database and click Next> ZBDCounters Database Setup - Settings
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 6 Install and configure SQL Manager 2005 Once installed, you need to register the two databases – ZBDCounters / Counters Register Database – ZBDCounters- Settings Use the current screen shots configuration below for each database registration
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 7 Register Database – Counters- Settings Link – Tesco Counters Database to ZBD Counters Database In SQL Manager – connect the ZBDCounters instance and run the following command to link Counters to ZBDCounters databases Command: -Using SQL Editor – ZBDCounters Instance use master Exec sp_addlinkedserver ‘(local)\Counters’
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 8 Registry Configuration Import the following Reg Key – RF_REG.reg from location c:\ZBDApps\ Check reg key location in regedit HKEY_CURRENT_USER\Software\VB and VBA Program Settings\TescoLabel Updater Batch Files Create shortcuts to the following batch file to location c:\Documents and Settings\ESEL\Start Menu\Programs\Startup from c:\ZBDApps Shortcut to startScales Shortcut to startTescoAdmin Shortcut to startTescoRFUpdater BIOS – Settings Power Management Setup - AC Loss Auto Restart – On Standard CMOS - Halt on [All, but Keyboard] Important .dll & .ocx Check that the following DLL & OCX files are available in c:\windows\system32 folder MSCOMCTL.ocx MSRDO20.dll COMDLG32.ocx MSCOMM32.ocx You may be required to register MSRDO20.dll Register .dll
Eng. No: 601-0009-01 ZBD Displays Limited Work Instructions Tesco Basestation Setup Instruction Strictly Private & Confidential © 2006 ZBD Displays Ltd Page 9 Command: regsvr32 c:\windows\system32\[.dll name] eg. regsvr32 c:\windows\system32\MSRDO20.dll Windows Firewall Settings Exceptions – Add Program Add all three sqlserver program executables to the exceptions list c:\Program Files\Microsoft SQL Server\MSSQL$ZBDCounters\Binn\Sqlserver.exe c:\Program Files\Microsoft SQL Server\MSSQL$Counters\Binn\Sqlserver.exe c:\Program Files\Microsoft SQL Server\MSSQL\Binn\Sqlserver.exe Attaching RF Dongle – (Matrix Dongle) Go to the following folder location as below c:\ZBDApps\WinDriver Install Double click on the Install batch file (install.bat) to install drivers for dongle. Next install the RF Dongle to any available USB port On the “Welcome to the found new Hardware wizard” box - Can windows connect to windows update to search for software Select – No, not at this time and click Next > Leave default – Install the software automatically (Recommended) and click Next > This will now install the appropriate drivers required. Once completed on the “Completing the found Hardware wizard” click Finish >

Navigation menu