Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cannot start more transactions on this server

Status
Not open for further replies.

daughtery

Programmer
Dec 12, 2006
66
US
I forgot to add the CommitTrans statement in one of my classes in vb6. Now I get the error "cannot start more transactions on this server". How can I go in and end the transactions and get rid of this error? I assume that not using the CommitTrans statement is the reason for the error, if not please correct me.
 
Hi

You'll probably get better luck in the VB Section, from a SQL point of view you can check on the server in the database in question if there are any open transactions with

DBCC OPENTRAN

if there are open transaction you could try killing the active spid if the vb sessions been disconnected, but I should have thought closing the app should have killed the transaction.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top