ADO Transaction Error: Cannot create new transaction because capacity was exceeded.
Posted on 2004-10-06
I'm using an ADO connection object in my VB6 app to connect to a SQL Server 2000 database. The connection works fine (I'm able to use the connection to populate recordsets, etc.), but when I try to call ADOcon.BeginTrans, it raises the error "Cannot create new transaction because capacity was exceeded." I have no other open transactions at the time of the error. I've searched the web and found minimal support on this error, and the few things I found did not solve my problem (increasing the database and transaction log sizes was the main one).