Vista Firewall Control Mobile Web Server Desktop Assistant IrDA Remote Control Company info


Vista Firewall Control
XP Firewall Control
Mobile Web Server
Desktop Assistant
IrDA Remote Control
LogAnalytics
Product
Download & Buy
Sample Output
Manual
Diagram List
Edit Diagram
DataSource List
Edit DataSource
File Log
Serial/PBX Log
TCP Log/Syslog
Database Log
Settings
Regular Expressions
Engines & SDKs
Portable Applications
Company info
Contact Us
Partners




Database Log

LogAnalytics allows you to analyze data from any connected database table directly via ODBC connection The connection string looks as follows

DSN=DSN_name;SQL="sql_statement" (for system DSN)
or
FileDSN=FileName;SQL="sql_statement" (for system FileDSN)

  • DSN or FileDSN are the ODBC source names (for System and File DSNs respectively). The DSN with the name should be previously created in the ODBC administrator. See Windows Control Panel for the details.
  • sql_statement means the SQL statement retrieving the data from a table (or table group). For example "select * from db" retrieves all fields from table "db" in the DSN specified.