I have a global connection object called cnText declared public in a module. In one of the forms I am using a transaction object with cnText to perform a certain database transaction. At the end I either commit or rollback. But when I try to use cnText after that elsewhere in the application (this time without any transaction object), it says that I need to initialize another transaction object because cnText is being used in a pending transaction. How do I continue to use cnText without having to close it and open it again?

I tried disposing the transaction object after rollback/commit, but it didn't work.

Thanks,
SM

Hi,

Apparently everything is working fine and there shouldn't be any problem. Any way, how's your application working with data? Is it using a DataSet to cache data and update the data source at a later time? If so, try synchronizing the DataSet with the underlying data source after a transaction commit or rollback by using the Update method of the DataAdapter and passing to it your DataSet. May be it helps.

Regards,

ejan