470,580 Members | 2,154 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,580 developers. It's quick & easy.

Transaction MS SQL

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
|__// |__|| | \\ \__// / \\ +------------------------------+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
Jul 23 '05 #1
3 1328
[BuKoX] (bu**********@tlen.pl) writes:
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?


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
Erland Sommarskog napisał(a):
What is D4?
Delphi 4 Standard
I don't recognize the message, but it sounds like it's an error from
a client component.
This message is translate from polish becouse I have Windows 2003 PL and
my component uses built in OLE DB driver (clinet side).
Do you have a code sample?


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
|__// |__|| | \\ \__// / \\ +------------------------------+
+[ http://bukox.prv.pl ][ http://total.bukox.dmkproject.pl ]+
Jul 23 '05 #3
[BuKoX] (bu**********@tlen.pl) writes:
Erland Sommarskog napisa?(a):
What is D4?


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


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


dbConn.CentralData.IsolationLevel := ilXactReadCommitted;
dbConn.Connection := dbParams;
dbConn.Connected := true;


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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by TZoner | last post: by
3 posts views Thread by Thiko | last post: by
2 posts views Thread by Deepak Mehta | last post: by
1 post views Thread by Avanish Pandey | last post: by
15 posts views Thread by Zeng | last post: by
1 post views Thread by Hubert Fröhlich | last post: by
1 post views Thread by Matik | last post: by
2 posts views Thread by Ryan Liu | last post: by
1 post views Thread by livre | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.