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
Del Murray
Delphi Developer
2003-09-20 06:56:43 AM
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.
Brian Bushay TeamB
Delphi Developer
2003-09-20 10:57:49 AM
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