***********************************************************
I n s t a l l a t i o n   I n s t r u c t i o n s
--------------------------------------------------------------------------

D a t a B a s e   s e r v e r :

Install SQL or MSDE

*********************

Installing MSDE

*********************

1.) execute the self extracting file MSDE2000A.exe
	This will start the extrating process. allow the extraction to 
	copy the files to the default location.

2.) copy the setup.ini file to the folder where the extracted files are.

3.) execute the setup.exe in the folder where the extracted files are.

4.) Restart the computer this will start the MSDE. You should see the icon 
    in the system tray.

------------------------------------------------------------------------------

Copying Data Base

copy the sql data base SKU_data.mdb and SKU_log.ldb to the 
"c:\program files\microsoft sql\mssql\data" folder.

These files are in the zipped file SKU_data.zip


------------------------------------------------------------------------------

Attaching the database:

copy scripts folder into c:\

In the scripts folder

execute the attachdb.bat to attach the SKU database.

------------------------------------------------------------------------------

Granting Access:

In the scripts folder...

execute the GrantAccess.bat to create the authentication. 

------------------------------------------------------------------------------
Edit the registry

Run the registry editor (Select Start | Run from the windows start menu, type 
regedit and then click OK). You can also do this from the command promt.

Set the value HKLM\Software\Microsoft\MSSqlserver\mssqlserver\LoginMode to 2. 

This tells your server to accept SQL Server & Windows authentication methods. 
Note HKLM stands for HKEY_Local_Machine.

exit the registryeditor

restart the MSDE  

from the command promt ( you can also do this through the services dialog )

NET STOP MSSQLSERVER
NET START MSSQLSERVER


------------------------------------------------------------------------------

ODBC:
 (pronounced as separate letters) Short for Open DataBase Connectivity.

On all client computers:
This includes terminals and terminal server.

create an entry under system dsn for SKUdb using the sql driver, point to 
the SKU database.

OS dependant
start > settings > control panel > administrator tools > data source (ODBC)  
Select System DSN (Data Source Name)
select add > SQL Server 
Name: SKUdb
Server: enter name of sql or MSDE server or IP
Next
Choose sql authentication
select client config > select tcp >ok
Check connect to sql server to obtain additional configuration options.
if using sql server authentication enter the user and password
Next
Check the change default database to: SKU
Next
Finish
Click on test, if you anything but success you are not connecting to the 
database. you must correct this for the client computer to access the database.

------------------------------------------------------------------------------
The files:

copy the contents of the files folder to the c:\pos folder ( backup before copy )

------------------------------------------------------------------------------

A simple connectivity test: 

snc_sql_view.exe can be use as a simple connectivity test

snc_sql_view.exe and glist.exe must be copyed to the c:\pos folder.

glist must be copyed to the c:\report folder.

create a shortcut for the snc_sql_view.exe

The command line on the shortcut should look like the following.

C:\pos\SNC_SQL_VIEW.exe /ODBC SKUdb /PLU C:\POS\POS-R /TYPE 16

Run the snc_sql_view shortcut

select the sql rewards list button, the glist screen should appear.

if not, something is wrong.

------------------------------------------------------------------------------

The POS Rewards:

you must have a plu for Rwards cards.
Example:

Use FDNmu to select plu's

add this plu to a preset for data base query.
80527 long name = *Rwards, short name = *Rwards, promt for modifiers = 1.

Use FDNPS to select preset mask to add the Rewards plu.

------------------------------------------------------------------------------

Running:

The SQL server or MSDE should be running.

start the terminal server snc_ts.exe

start the terminal program

logon to the terminal, start an order, touch the Rwards key, enter rewards manually or via magnetic card reader.