Not enough capacity to start transaction

[creeker]

Hi there,

Problem with SDAC 3.55.1.19 / 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';

Problem:
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."
or
"MSSQL error: Not enough capacity to start transaction."

if the FetchAll property True, the error not occurted.

Anybody run into this error ?

[Ikar]

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.