Board index » delphi » Is there Any SQL monitor for ADO ?

Is there Any SQL monitor for ADO ?


2003-09-20 03:23:20 AM
delphi196
I think SQL-Monitor that comes with Delphi 7 does
not work with TADOTable, TADOQuery, TADODataset, TADODataset, etc.
Or any simple way to see actual SQL statements that go to the database
server ?
Thanks,
Ashok
 
 

Re:Is there Any SQL monitor for ADO ?

Your database may have a monitor utility with it. SQL Server does, you just
turn it on or turn it off in Enterprise manager.
 

Re:Is there Any SQL monitor for ADO ?

Quote
I think SQL-Monitor that comes with Delphi 7 does
not work with TADOTable, TADOQuery, TADODataset, TADODataset, etc.
correct
Quote
Or any simple way to see actual SQL statements that go to the database
server ?
No ADO creates the SQL and there is no generic ADO tool for this. You have to
use what ever your database provides. SQL server Query Profiler tool will do
this if you are using SQL server