Tracking SQL Calls From MS Access to MySQL

Question

I'm trying to 'see' the SQL statements that are sent from MS Access 2003 to MySQL via ODBC.

I've tried ODBC Tracing, but it's painfully slow, producing very large log files which are very difficult to read.

For example, and insert looked like this:

"INSERT INTO  `tracking`  (`contract_id`,`bp_id`,`csi_1`,`csi_2a`,`csi_2b`,`csi_code`,`item_number`,`csi_code_display`,`csi_name`) 
VALUES (?,?,?,?,?,?,?,?,?)\ 0"

It doesn't show the values, I think they are coded separately as SQLBindParameters, but I can't make out the values in those either.

Is there an alternate/better method that I can use to simply see the full SQL statements?

MTIA

Answer 1

MySQL Proxy should do what you're after.

Answer 2

Who's MySQL driver are you using?