Re: Error: Cannot create new transaction because capacity was exceeded

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.

"Robert Morley" <rmorley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:OJNkijVHGHA.2212@xxxxxxxxxxxxxxxxxxxxxxx
> Is it possible that there's a small bug in the code, and you were opening
> the transaction repeatedly?
>
>
>
> Rob
>
> "Martin" <kashaan007@xxxxxxxxxxx> wrote in message
> news:e0zmSLTHGHA.3532@xxxxxxxxxxxxxxxxxxxxxxx
>>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.
>>
>> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
>> wrote in message news:e%23vpdATHGHA.376@xxxxxxxxxxxxxxxxxxxxxxx
>>> Maybe a file size limitation on the Log file?
>>>
>>> --
>>> Sylvain Lafontaine, ing.
>>> MVP - Technologies Virtual-PC
>>> E-mail: http://cerbermail.com/?QugbLEWINF
>>>
>>>
>>> "Martin" <kashaan007@xxxxxxxxxxx> wrote in message
>>> news:efk9%23HSHGHA.1728@xxxxxxxxxxxxxxxxxxxxxxx
>>>> 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.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages
Quantcast