Database

Top  Previous  Next

The database is based on Microsoft Northwind database.

 

The primary keys where replaced with string 12 characters codes.

Two fields where added to each table:

       - sid  - code of the last user who modified the record

       - mdl - datetime of the last update of the record

 

There are three databases servers to chose from:

 

- Ms. SQL database

- PostgreSQL

- Sqlite 3.0

 

The application work in the same manner with all of them (Sqlite 3.0 can be used with fewer users only).

 

By default the server is installed with the Sqlite 3.0 database as there no installation is required for the database.

 

The databases backups for PostgreSql and Ms. SQL are in the DB_back directory. To change the database just install the databases from backup and modify the server connection strings as follow.

 

There are two connections strings to be modified:

- server main connection (server configuration program)

- reports management - connections

 

Samples of connection strings:

 

PostgreSql

Driver={PostgreSQL UNICODE};Server=localhost;Database=northwind;Port=5432;Uid=postgres;Pwd=123456;SSL=No;

 

MS.Sql

Driver={SQL Server};Server=ADRIAN-PC\SQLEXPRESS;Database=northwind_psg; Uid=sa;Pwd=123456;

 

Sqlite 3.0

DRIVER=SQLite3 ODBC Driver;Database=C:\projects\wwb\db3\psg\northwind.db3;LongNames=0;Timeout=1000;NoTXN=0;SyncPragma=NORMAL;StepAPI=0;