Page 1 of 1

dbMonitor does not record in run time

Posted: Wed 20 Jun 2018 15:03
by Rober2018
I am testing on delphi 10 Seatle, sdac 8.0.1 and dbmonitor 3.0.4. I used a TMSConnection, a TMSquery and a TMSSQLMonitor. I put a simple query and at design time I activated the TMSConnection and the TMSQuery, the dbMonitor registers perfectly. In run time the dbMonitor does not register any event. Any suggestions?

Re: dbMonitor does not record in run time

Posted: Fri 22 Jun 2018 14:07
by Stellar
Event logging in dbMonitor is performed by sending packets via the TCP protocol. It is possible that the packets are blocked by antivirus software or a firewall.

Re: dbMonitor does not record in run time

Posted: Fri 22 Jun 2018 16:33
by Rober2018
Maybe, but it works in design time ... but in runtime it fails

Re: dbMonitor does not record in run time

Posted: Tue 26 Jun 2018 10:36
by Stellar
The difference is that in design-time the connection to dbMonitor is executed using IDE, and in real-time the connection is executed from the compiled exe-file of the project. Antivirus software or a firewall can treat the IDE as a trusted program, but a new file as non-trustware and restrict the access. Please try disabling antivirus software or a firewall and test the work of dbMonitor in real-time. Also, you can try specifying the port in dbMonitor settings (dbMonitor - Tools - Options - Port number for client connections), for example 6100. And for the TMSSQLMonitor component, set the Port property to 6100, and for the Host parameter, specify the to localhost value.

Re: dbMonitor does not record in run time

Posted: Tue 26 Jun 2018 13:47
by Rober2018
It is possible that this is the problem. Thank you very much