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

I don t know why this question popped up today in the "new questions" list, but it did, and I just Googled "sql profiler for mysql" and came up with this:

http://dev.mysql.com/tech-resources/articles/using-new-query-profiler.html

I don t know if it is better, or if it works with the version of MySQL used by the original question, but I thought it might be useful to others who came to the question.

友情链接