Hello.
I use ADO components in D4 and connect to MS SQL. I create new
transaction in ADO but an error occures: "You can't run more
transactions in this session". I use isolation level - ReadCommited. I
dont't run any transaction so I don't know what's wrong?

bye...

--
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +------------------------------+

[BuKoX] (bukox.wytnij@tlen.pl) writes:
[quoted text, click to view]

What is D4?

I don't recognize the message, but it sounds like it's an error from
a client component.

Do you have a code sample?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at

Erland Sommarskog napisał(a):

[quoted text, click to view]

Delphi 4 Standard

[quoted text, click to view]

This message is translate from polish becouse I have Windows 2003 PL and
my component uses built in OLE DB driver (clinet side).

[quoted text, click to view]

dbConn.CentralData.IsolationLevel := ilXactReadCommitted;
dbConn.Connection := dbParams;
dbConn.Connected := true;
....
dbConn.CentralaData.StartTransaction() // this error occured here
qQuery.Master := dbConn;
try
qQuery.Open;
while not qQuery.Eof do
begin
...
qQuery.Next;
end;
qQuery.Close;
except
on e:exception do
begin
qQuery.Close;
dbConn.CentralData.RollbackTranasaction();
exit;
end;
end;
dbConn.CentralData.CommitTransaction();

bye...

--
__ __
|__\\ | || |_// / \\ \_// FreeBSD: The Power To Serve
|__// |__|| | \\ \__// / \\ +------------------------------+

[BuKoX] (bukox.wytnij@tlen.pl) writes:
[quoted text, click to view]

You may call that ADO, but the names of the properties and methods
are nothing that I recognize. Then again, I don't know Delphi.

So unfortunately, I will have to pass on this one.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at