Cannot start more transactions on this session

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CB - 30 Oct 2003 22:29 GMT

A user received this message (subject line) while trying
to add a record to one table in a SQL Server 2000 database
accessed through VB 6 and ADO. The application was the
only one on his machine running against the database. The
Microsoft Knowledge Base has an article (316782) but it is
for VB.Net. It claims that the application was trying to
start more than one transaction and that SQL Server
doesn't allow nested transactions. The application was
using only one transaction and it was not nested.

Cannot find anything else on Microsoft website about this
error. Help!

Reply to this Message

Vadim Rapp - 31 Oct 2003 08:40 GMT

C> A user received this message (subject line) while
C> trying to add a record to one table in a SQL Server
C> 2000 database accessed through VB 6 and ADO. The
C> application was the only one on his machine running
C> against the database. The Microsoft Knowledge Base
C> has an article (316782) but it is for VB.Net. It
C> claims that the application was trying to start
C> more than one transaction and that SQL Server
C> doesn't allow nested transactions. The application
C> was using only one transaction and it was not
C> nested.

are there any triggers on the table?

Vadim

----------------------------------------
Vadim Rapp Consulting
SQL, Access, VB Solutions
847-685-9073
www.vadimrapp.com

Reply to this Message

CB - 31 Oct 2003 14:06 GMT

No triggers on that table. Another user got the same
message with another table that does have triggers.
However, none of the triggers have transactions in them.

>-----Original Message-----
>C> A user received this message (subject line) while
[quoted text clipped - 19 lines]
>www.vadimrapp.com
>.

Reply to this Message

Juergen - 27 Nov 2003 13:13 GMT

Are you using Forward Only Cursors? If you open two
Forward Only Cursors the SQL-Server will not be able to
start any transaction.

>-----Original Message-----
>No triggers on that table. Another user got the same
[quoted text clipped - 26 lines]
>>
>.

Reply to this Message

viperfish - 19 Jul 2005 18:28 GMT

CB,

Did you ever get this issue resolved ? I am facing a similar
situation.

-Sam

> *A user received this message (subject line) while trying
> to add a record to one table in a SQL Server 2000 database
[quoted text clipped - 8 lines]
> Cannot find anything else on Microsoft website about this
> error. Help! *

--
viperfish

Reply to this Message