At 10:00 PM 23/10/2007, you wrote:

>Helen,
>
>I'm using Delphi with dbExpress and ClientDatasets in a 3-tier app.
>My transaction configuration is:
>
>CommitRetain=False
>Interbase TransIsolation=ReadCommited
>
>dbExpress should handle transactions automatically and I never worried about it.
>
>What do you mean by "some abandoned ClientDataset"? My app is 3-tier,
>so the ClientDataset is completely disconnected. My app server is
>stateless. The db connection is not owned by any client.

The provider has to be within the context of connection and transaction, though. Do you call Commit on the provider's transaction after populating your ClientDataset?

./heLen