MICROS Retail OSCAR POS with SQL Database

By default, the MICROS Retail OSCAR POS application is delivered with an ISAM database. In variation from the standard database, the MICROS Retail OSCAR POS application can also be operated with ORACLE 8.0 and MS SQL Server 7.0.

The following settings are necessary to operate the POS clients with an SQL database:

1. In file "oscar.ini"
   MICROS Retail OSCAR POS_SQL_ONTILL=y

The name of the client database matches the name of the SQL database with the number of the processing unit as entered in file oscar.ini. If, for example, the name of the SQL database is "oscar_db" then the SQL client database for processing unit 5 will be given the name "oscar_db5".

Example:
MICROS Retail OSCAR POS_SQL_PASSWD=

MICROS Retail OSCAR POS_SQL_USER=

MICROS Retail OSCAR POS_SQL=oscar_db
MICROS Retail OSCAR POS_SQL_ONTILL=y

The empty SQL client databases should also be created manually as for the empty server database before they can be used. The user and the password must be identical with the user of the server database. The tables of the SQL database are loaded after the first start up operation of the POS clients.

Please note that an ODBC connection must be generated for each SQL client database.

Example

• oscar_db         MICROS Retail OSCAR POS server
• oscar_db5       Process unit 1 of POS 1
• oscar_db101   Process unit 101 of POS 2

Note:
It is possible to export an existing MICROS Retail OSCAR POS ISAM file to an installed SQL database and to import an MICROS Retail OSCAR POS SQL database in an ISAM file. By use of the parameter MICROS Retail OSCAR POS_SQL="Name of ODBC database source " in the file "oscar.ini", you define that the MICROS Retail OSCAR POS application is to work with an SQL database.

The command for the export of the MICROS Retail OSCAR POS ISAM database in an MICROS Retail OSCAR POS SQL database is:

• oscar isamtosql

The command for the import of the MICROS Retail OSCAR POS SQL database in an MICROS Retail OSCAR POS ISAM database is:

• oscar sqltoisam

These commands have to be executed from the directory work.

---

The operation of the MICROS Retail OSCAR POS application with an MS SQL Server 7.0 database requires the following:

Example:

• MS SQL-Server 7.0 with Service-Pack 1
• User "john_doe" (with administrator access authorisation for the database creation)
• running SQL Server

SQL-DB Configuration

• Start the SQL Server Manager (Start -> Programs-> SQL Server 7.0 -> Enterprise Manager)
• Generate a new database (e.g. database "OscarDBSB") in Database -> New Database
• Define a new user for the database if applicable (e.g: oscaradmin) in Menu Security -> User name-> New user name)
• Define the database access for the new user.

DSN (=Data-Source Name) Configuration

• Start the ODBC administration in Start -> Programs -> Administration-> Data sources - ODBC (Windows 2000 computer)
• Add SystemDNS; select the driver "SQL Server".
• Configure SystemDSN 'oscardsn'.
  The name for the description of the DNS is the name of the ODBC database source that has to be entered as the parameter for the variable MICROS Retail OSCAR POS_SQL in the file oscar.ini.

Note:
By running a  64 bit system, the ODBC application "%WINDIR%\SysWow64\odbcad32.exe" must be used.
The option "Regional settings" for the currency output must not be used (otherwise e.g. item numbers greater than 999 will not be displayed correctly).

• Finish and test the OBDC data source.

Changes in Oscar

Preparation

• Delete possibly existing obsolete "odbc*.dll" files in the directory ../oscar/bin

Modifications in the configuration file "oscar.ini"

• Parameter setting: ODBCDEBUG=Y
• If applicable, record MICROS Retail OSCAR POS_CONSOLE=Y or "file name"
• Enter new DSN: MICROS Retail OSCAR POS_SQL=oscardsn
• For MICROS Retail OSCAR POS_SERVER= check the related IP address.

Conversion ISAM->SQL / Implementation SQL

Version 1 – ISAM database is already there

• Prompt: Start the conversion via the command oscar isamtosql
• The recording takes place in the file: errlog.login

Version 2 – New generation of the database

• With new database, start via the command oscar init

Control

• Open the new database directly (with Enterprise Manager). Check for newly-created tables.
• The conversion is recorded in the file errlog.login

Start MICROS Retail OSCAR POS with SQL-Server DB

• Start MICROS Retail OSCAR POS with the new SQL database via the command oscar start

---

 Click on the image to return to the Table of Contents.

---

MICROS Retail Deutschland GmbH
Salzufer 8
D-10587 Berlin