We are using a Delphi TClientDataSet to propagate changes from a local database to a remote SQL Server on our website server. We open the set of records on the local database and open a ClientDataSet with the data from SQL Server. We compare the two and update the ClientDataSet where required. These changes are then applied back to the SQL Server database by calling ApplyUpdates. This has been working fine for a while , but now we are getting the error
Operation not allowed when the object is closed
when attempting to call ApplyUpdates on the ClientDataSet. No changes have been made to the code or the local environment and we are getting the same error in the development site and on the client's site.
Any ideas!! We are using Delphi 6 and a TADOConnection to the SQLServer, running under Windows 7 Prof 32 bit.