Error message occurs when you use OLE DB Provider for SQL Server in ADO.NET: "Cannot start more transactions on this session" (316872)
The information in this article applies to:
- Microsoft ADO.Net 2.0
- Microsoft ADO.NET (included with the .NET Framework) 1.0
- Microsoft ADO.NET (included with the .NET Framework 1.1)
- Microsoft SQL Server 2000 (all editions)
This article was previously published under Q316872
This article refers to the following Microsoft .NET Framework Class Library namespaces:
- System.Data
- System.Data.OleDb
- System.Data.SqlClient
SYMPTOMS
When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message:
System.Data.OleDb.OleDbException: Cannot start more transactions on this session
CAUSE
By design, OLE DB Provider for SQL Server does not allow nested transactions.
REFERENCESFor additional information, click the article number below
to view the article in the Microsoft Knowledge Base:
306649 PRB: Error When You Implement Nested Transaction with OLE DB Provider for SQL Provider
Modification Type: | Minor | Last Reviewed: | 3/9/2006 |
---|
Keywords: | kbtshoot kberrmsg kbpending kbprb kbSystemData KB316872 kbAudDeveloper |
---|
|