SQL CE Transaction Problem

[Guest]

Hi,

I have a VB.NET application running on a PocketPC using a SQL CE database. I
am executing SQL against the database in transactions. Every so often an
error is occurring that contains the following message:

"This SqlCeTransaction has completed; it is no longer usable"

Does anyone know exactly what would cause this error?

Thanks.

 

[W.G. Ryan MVP]

Mike:

Are you calling commit on the transaction any time before hand?