# ODBC Logging

To turn ODBC Logging on, create in "ODBC Data Source Administrator" a data source named "ArgusLog". In the database, create a table named LogStrings with the following mandatory columns: three text columns called "Logger", "RecTag", and "RecMsg" and a timestamp column "RecTime". You may also add additional 'row number' fields, but make sure they are automatically updated, Argus would never write there. Argus doesn't currently log other information to ODBC. To add log records, Argus executes the following SQL statement:

    INSERT INTO LogStrings (Logger, RecTag, RecTime, RecMsg) VALUES (?, ?, ?, ?)

You may issue the following SQL statement to create LogStrings table under Microsoft Access:

    create table LogStrings (
       RecId counter NOT NULL CONSTRAINT RecIdIndex PRIMARY KEY,
       Logger char(20) NOT NULL,
       RecTag char(1) NOT NULL,
       RecTime date NOT NULL,
       RecMsg char(250) NOT NULL);

Then go to Config/Start-up, turn ODBC logging on and restart Argus. ODBC errors are logged to "odbcerr.log" file in Argus logs directory.