Not enough capacity to start transaction

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 3
Joined: Wed 12 Oct 2005 13:58
Location: Hungary

Not enough capacity to start transaction

Post by creeker » Fri 14 Oct 2005 09:04

Hi there,

Problem with SDAC / D5 (built6.18) /MSSQL2000(8.00.194)

table:(have 50 records)
create table crk_test (
crk_test_id int not null identity(1, 1),
crk_text varchar(100)
constraint pk_crk_test primary key (crk_test_id)

MSConn : TMSConnection;
MSQuery1: TMSQuery;
MSQuery2: TMSQuery;

query settings:
FetchAll := False;
SQL.Text := 'select * from crk_test';

When I open MSQuery1 and make MSConn.StartTransaction, everything was done.
But if I open more datasets (like MSQuery1 and MSQuery2) before I make
MSConn.StartTransaction, I got one of these error messages:

"Cannot create new transaction because capacity was exceeded."
"MSSQL error: Not enough capacity to start transaction."

if the FetchAll property True, the error not occurted.

Anybody run into this error ?

Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Fri 14 Oct 2005 09:11

Unfortunately the way of using FetchAll set to False with all its advantages has some imperfections including transactions conflict. You can read SDAC help or MSDN for details.

Post Reply