Error: Cannot create new transaction because capacity was exceeded

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

Hi everyone,

I have an adp project I have been using for some months now, but this
morning I got the following error:

Cannot create new transaction because capacity was exceeded.

I get the error in a ADO code with a transaction block.

Can anyone tell me why I get this, when previously this code had worked
without any problems.

And what the cause is of this error?

TIA,

Martin.
 
I checked the transaction log file size, it had about 53 MB of free space
and no limitation on growth.

Any other possible problems?

Martin.
 
Is it possible that there's a small bug in the code, and you were opening
the transaction repeatedly?



Rob
 
Well the code is not in any kind of loop, so I don't think that can be the
problem.

As I said earlier the very same code has been working for about 8 months
now, without any errors.

I did some research on the net and found that others have experienced this
error also.

They say it's some kind of limitation in sqloledb.dll, but this concerns a
borland product.

http://bdn.borland.com/article/0,1410,32020,00.html

Anyone know a workaround for VB?

TIA,

Martin.
 
Back
Top