Cannot start more transactions on this session -- sql server clients

Vadim Rapp
10/31/2003 1:40:46 AM

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

CB
10/31/2003 5:06:34 AM

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.

[quoted text, click to view]

Juergen
11/27/2003 5:13:14 AM

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

[quoted text, click to view]

viperfish
7/19/2005 12:28:36 PM

CB,

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

-Sam

[quoted text, click to view]

--
viperfish
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message32628.html

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server clients

sql server clients : Cannot start more transactions on this session