5.16. Log to Databasepdf

    This module works on all the records in the other filters and exports the log into a database. Following shows [Log to Database Config] dialog:

Operation instruction:

  1. In the [Log cache size] blank, fill up a number.
  2. Press <Browse> to direct a database link file.
  3. Press <Test> to test the database link whether it works or not.
  4. Press <Config> to modify the database information in UDL file.
    Additional instruction:

Additional instruction:

  1. [Log cache size]: this number represents a maximum number how many records can be stored in cache, is 100 by default. A bigger number will cost more memory, while a smaller number will lead to low performance because of too many operations in hard disk I/O.
  2. [Db link file]: UDL file is used for connecting the database. UDL is Usual Database Link file for short, which stores a string which connects the database.
  3. The <Active Wall> installation has a database of Access type. Users can export to the database of Access directly, or can create a new database and modify the UDL file.
  4. The following statement is used to create a database table structure:
    CREATE TABLE [EventLog] (
    [ID] [int] IDENTITY (1, 1) PRIMARY KEY ,
    [EventTime] [datetime] NOT NULL ,
    [LanIP] [nvarchar] (15) NOT NULL ,
    [WanIP] [nvarchar] (15) NOT NULL ,
    [PlugIn] [nvarchar] (20) NOT NULL ,
    [Act] [int] NOT NULL ,
    [Msg] [nvarchar] (255) NOT NULL ,
    [Res] [ntext] NULL
    )
Active Network CO., Ltd