Pervasive v10 sp2 transaction logging
Posted on 2010-11-08
We have a (mission critical) application that uses Pervasive for it's database engine. The problem is that a specific field in random records is getting either blanked or the digits scrambled. I believe it to be a user that is using an ODBC connection to query the data in to a excel poorly written/created the excel sheet.
The application itself does not do any logging so my thought is to do auditing / transaction logging on the pervasive database server itself to find the source of the data corruption. So far the application developer has been very slow to respond to my issue if responding at all. I need to take more drastic measures in to my own hands.
Can I do this monitoring / transaction tracking with the tools that come with pervasive 10? I saw under the "debugging" section in the pvsw control center an option "trace operation". Does this log users actions, who changed what and when? I looked at the help file and the sample output looked like the data was in hex, there were no user name and I couldn't tell what exactly was changed. That data might be good to a programmer but I am not that.
Are there other (free) tools that will allow me to do what I need or do I need to purchase a package like Pervasive's Audit program?
Thanks in advance.