Control SQL queries executed by Delphi application

Question

I would like to track the SQL queries that my application executes during its launch.

I am using a dbExpress connection to an Oracle 11g database in Delphi 2007.

This was possible within BDE using the sqlmon.exe utility.

Is there a similar utility for dbExpress?

I tried Toad SQL Monitor, which logs two or three queries, and then the application freezes quickly. I can set up a full-scale Oracle trace, but it's too complicated for everyday debugging.

Answer 1

To track requests, you need to use the delegate trace driver.

Read this link , it gives more information about dbexpress 4 and delphi 2007. Note for D2009 users: with D2009 you no longer need to configure ini files, just use the object inspector, it makes it possible to add delegate drivers directly in the IDE.