Logging to MySql

[930driver]

I'm trying to log ISA events to MySql. MySql is set up and works. The report table is set up as specified. I have the DSN set up and ISA configured to use it. No reports of problems but no files appear in the table.

When I turning on ODBC tracing the log shows a series of events including connecting to the MySql database and an attempt to write records.

Two interesting things. First there is an entry for 'SQLBindParameter' with a return code of -1 (SQL_ERROR), also 'SQL data type out of range'. Second, the SQL statement that is attempted includes a values clause that consists of question marks only:

Insert into ... Values( ?, ?, ?, ...)

Clearly it shouldn't be trying to write question marks, but rather actual values.

Has anyone successfully logged ISA events to MySql, and if so, any suggestions? Does anyone know how to resolve my above problems?

Thanks much. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"

 

[930driver]

I have my own answer to this now.

ISA does not like to log to non-MS databases. Create the tables in MySql using the ISA supplied create-table sql. Then create an Access database and link to the MySql tables. Log to this Access database. This fools ISA into thinking it's going to Access which in turn passes it to MySql. "The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"