Database Log : LogAnalytics : Sphinx Software

		Windows 7 Firewall Control
		Mobile Web Server
		Lookup 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
		Communication Tunnel
		Portable Applications
		Tools
		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.