We started using the Devart driver a short time ago with the objective of creating in our ERP a routine monitoring functionality.
This functionality, when enabled, has as one of the main requirements, storing all the submitted messages to the database. The main reason we start using the devart driver is to improve the capture of information, since the default driver does not provide complete information.
However, we are faced with a critical problem: the driver apparently does not provide support for fetching queries larger than 1023 characters.
We are conducting tests in two ways:
- With the TSQLMonitor component (dbExpress). This component uses a record (SQLTraceDesc) to capture information that is limited to 1023 characters. We made a change in this implementation, creating another component inherited from TSQLMonitor to solve this limitation, but we did not succeed;
- Alternatively, we try to intercept the queries by the TraceCallBack event of the connection. In this case we do not have the TSQLMonitor component limitation. But we were not successful either.
We are using Delphi 7 + MSSQL 2008R2 + Driver Devart 7.4.6.0