dbMonitor does not record in run time

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
Rober2018
Posts: 3
Joined: Wed 20 Jun 2018 14:51

dbMonitor does not record in run time

Post by Rober2018 » Wed 20 Jun 2018 15:03

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?

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: dbMonitor does not record in run time

Post by Stellar » Fri 22 Jun 2018 14:07

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.

Rober2018
Posts: 3
Joined: Wed 20 Jun 2018 14:51

Re: dbMonitor does not record in run time

Post by Rober2018 » Fri 22 Jun 2018 16:33

Maybe, but it works in design time ... but in runtime it fails

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: dbMonitor does not record in run time

Post by Stellar » Tue 26 Jun 2018 10:36

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.

Rober2018
Posts: 3
Joined: Wed 20 Jun 2018 14:51

Re: dbMonitor does not record in run time

Post by Rober2018 » Tue 26 Jun 2018 13:47

It is possible that this is the problem. Thank you very much

Post Reply