I'm connecting to a Progress 8.x db (sorry - don't know the exact version) using the Merant 4.0 ODBC driver (from a C# NT service). I am experiencing severe delays in seeing new rows written to a large busy database. The Progress system which writes the rows also writes an entry to a small database which I monitor: when I see a new row in this 'gateway' database my program goes off to the main database to pick up the new rows - but doesn't find them! It can take up to 22 hours before they become visible. (By visible I mean that a select actually returns data rather than an empty result set.)
Has anyone else seen this? Any idea of possible causes and fixes or work-arounds?
Thanks very much -
Simon
Has anyone else seen this? Any idea of possible causes and fixes or work-arounds?
Thanks very much -
Simon