Displaydata 120-0039-05 Users Manual
Eng. No: 601-0009-01
ZBD Displays Limited
Work Instructions
Tesco Basestation Setup
Instruction
Work Instructions
Tesco Basestation Setup
Instruction
Abstract
This document defines the setup to be used for the Tesco Basestation.
Prepared by:
Shiv Sidar
Authorised by:
D.Dix
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 c hange without written noti ce and should no t
be construed as a commitment by ZBD Displays Ltd. unless suc h commitment is expressly giv en in a
covering document.
Signed:
Signed:
© Copyright ZBD Displays Ltd. (2006)
Date:
11/09/2006
Date:
11/09/2006
Strictly Private & Confidential
© 2006 ZBD Displays Ltd
Page i
Eng. No: 601-0009-01
ZBD Displays Limited
Work Instructions
Tesco Basestation Setup
Instruction
TABLE OF CONTENTS
1 INTRODUCTION..................................................................................................................... 1
2 APPLICABLE DOCUMENTS...............................................................................................1
3 TESCO BASESTATION SETUP INSTRUCTION........................................................1
Strictly Private & Confidential
© 2006 ZBD Displays Ltd
Page ii
Eng. No: 601-0009-01
ZBD Displays Limited
Work Instructions
Tesco Basestation Setup
Instruction
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]\[ Set up 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
Strictly Private & Confidential
© 2006 ZBD Displays Ltd
Page 1
Eng. No: 601-0009-01
ZBD Displays Limited
Work Instructions
Tesco Basestation Setup
Instruction
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
Strictly Private & Confidential
© 2006 ZBD Displays Ltd
Page 2
Loading...