Note for using the iServer

iServer is Windows based program to collect transaction records from iGuards and to save them on ODBC database format.

iServer is default using Microsoft Access. If you decide to use MS Access, no supplement changes have to be made.

However, if you want to use other ODBC compatible database, you have to do the following things in order to get the iServer connect to the database. The syntax is subject to the database you have.

You need to create a database, and create 2 tables. We have examples from 2 kinds of databases.

The Table Structure of the Default MS Access (ibonussrv.mdb):

MS Access

Table: AccessLog
RCDID Int AUTO_INCREMENT,
EmployeeID char(16),
LogDate char(10),
LogTime char(10),
TerminalID char(20),
InOut Int,
Primary Key(RCDID, EmployeeID, LogDate, LogTime, TerminalID)

Table: Employee
EmployeeID char(16),
LastName char(40),
FirstName char(40),
OtherName char(40),
Password char(16),
EmpStatus Int,
NumMinutiae1 Int,
NumMinutiae2 Int,
PhotoFile char(40),
Minutiae1 image,
Minutiae2 image,
Photo image,
Department char(50),
Primary Key(EmployeeID)

There are some differences in the syntax of creating the table in other database like SQL Sever and Oracle. The following is for you reference.

SQL Server

Table: AccessLog
RCDID Int IDENTITY yes,
EmployeeID char(16),
LogDate char(10),
LogTime char(10),
TerminalID char(20),
InOut Int,
Primary Key(RCDID, EmployeeID, LogDate, LogTime, TerminalID)

Table: Employee

The same syntax as MS Access

The database created in SQL Server need to have a login in order to access the tables. Can do it in the step of creating the DSN later.

Oracle

Table: AccessLog
RCDID Number(38) Not Null, <- Contraint – Auto Increment field
EmployeeID Char(16) Not Null,
LogDate Char(10) Not Null,
LogTime Char(10) Not Null,
TerminalID Char(20) Not Null,
InOut Number(38)

Table: Employee
EmployeeID Char(16) Not Null,
LastName Char(40),
FirstName Char(40),
OtherName Char(40),
Password Char(40),
EmpStatus Number(38),
NumMinutiae1 Number(38),
NumMinutiae2 Number(38),
PhotoFile Char(40),
Minutiae1 BLOB,
Minutiae2 BLOB,
Photo BLOB,
Department Varchar2(50)

It has many method to create a table in Oracle and to do the auto increment field (RCDID). The following method are the most common.

    1. To create an Oracle table :
      a) you can use an administration tools in Oracle for table manipulation if you use version which is 8 or later, or ;
      b) you can use sql command to create table in sql plus or sql worksheet.
    2. To create a field for auto increment (RCDID):
      a) To create a sequence and add a constriant to a field, or ;
      b) Create a trigger to increment the field.

The same as SQL Server, you need to have a login for the database. You must make sure the username and password is correct and the username should have right access the AccessLog and Employee. You must aware that users in Oracle have their own right to access table. If you do not have username and password, you could not enter into the Oracle database. If your username does not have any right to access the table, you could not do anything to that table even you could log in to the Oracle database. After you have the login for the database, you can test it as the following.

Testing (Optional):
1) Use SQL Plus to login as the same username and password as in iServer.
2) Try select and insert statement to that table in SQL Plus.

In Control Panels -> Administrative tools -> ODBC -> System DSN -> Add

For SQL Server and Oracle database, the procedure is similar.

Please specified the Data Source Name to default “iServer”.

For SQL Server database, you can use the login username, say “sa” which has a greatest privilege, and password to create the DSN.

For Oracle, you can try to choose driver “Orahome” if you have and this is the way from our customer success.

Finally, this is worked fine when you start iServer. When you are using the ODBC compatible database other than MS Access, do not choose to create MS Access when it prompted you for the first run.