Error: Cannot create new transaction because capacity was exceeded

[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.

 

[Sylvain Lafontaine]

Maybe a file size limitation on the Log file?

 

[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.

 

[Robert Morley]

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



Rob

 

[Martin]

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.