How to trace ADO calls

Question

Friends, Is there a tool available to trace all sql statements passed between ADO (legacy vb6) (NOT ADO.NET) and database server? Appreciate your help

Answer 1

Have you already seen this free (as in beer) Statement Tracer for ADO app by some Above Software? From program site:

Solution for monitoring SQL queries to Microsoft® ActiveX® Data Objects (ADO) data sources.

• Monitoring any number of applications.
• Tracing ADO queries in real time.
• Enabling and disabling monitoring at any moment.

Frankly, I never used or heard about it before. But quick test with VB6 ADO app vs. SQL Server 2008 Express looks good: the tool did capture connection string from ADODB.Connection.Open() and SQL statement text from ADODB.Connection.Execute().