Nested Transactions

Can anyone verify for me whether SQL Server CE 2.0 does or does not support nested Transactions when using the SQLServerCe Data Provider? The SQL Server CE Books Online documentation definitely states that SQL Server CE supports nested Transactions, but the example provided uses ADOCE Data Provider. The error message that I get when trying to begin a new Transaction with an existing Transaction still uncommitted on the same SqlCeConnection is "SQL Server CE does not support parallel transactions". Is it not possible to nest Transactions with SQLServerCE Data Provider?

SQL Server CE doesn't support nested transactions. Meaning you can't start a transaction B inside transaction A. Can you please point us the help link that you came across?

Thanks

Raja

|||

SQL Server CE 2.0 Books Online -

under the topic "Using Transactions", the second bullet point under that topic states:

"In SQL Server CE, transactions can be nested up to five levels deep."

under the topic "Transactions", the second bullet point states:

"When a maximum of five levels of transaction nesting have been reached, StartTransaction returns an error indicating that no further transactions can be started. "

However, under the topic "Data Provider for SQL Server CE", subheading "Provider Limitations" I see that the third bullet point states:

"No support for nested or parallel transactions. "

So my understanding is that the whether the SQL CE database engine supports transactions or not (I'm still uncertain of this), the SqlServerCe Data Provider explicitly does not. I am curious to know if this situation remains true in SQL Server 2005 Mobile Edition. If I can use nested Transactions with SqlServerCe Data Provider in 2005 Mobile Edition, my best course may be to upgrade my database.

thanks,

Max

|||

Thanks for the information. I didn't know that.

SQL Mobile doesn't support nested transactions either through oledb provider or ADO. You can refer to the following links:

http://msdn2.microsoft.com/en-gb/library/ms174571.aspx

http://msdn2.microsoft.com/en-us/library/ms174044.aspx

Thanks

Raja