A request to establish a connection with the transaction manager was denied.

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
so-photo
Posts: 5
Joined: Thu 26 Apr 2018 11:11

A request to establish a connection with the transaction manager was denied.

Post by so-photo » Tue 29 May 2018 10:47

Hi,

we have a big Problem...

When i try to update a field in the database following error occurs:

A request to establish a connection with the transaction manager was denied.

It occurs only with the MSTable - Edit and Post. If i use TMSQuery or TMSSQL with Update there's no error...


I have no idea whats this about ???

Delphi XE7 - MS SQL Ver. 14



Thanks!

so-photo
Posts: 5
Joined: Thu 26 Apr 2018 11:11

Update: A request to establish a connection with the transaction manager was denied.

Post by so-photo » Tue 29 May 2018 15:53

Hi,

I've found something mystic... :-)

if I use lmNone, there's no error!!!!

But if I use lmPessimistic or lmOptimistic it runs always to an error!
I can't use lmNone cause it's a multiuser application...

But what can I do????

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: A request to establish a connection with the transaction manager was denied.

Post by Stellar » Wed 30 May 2018 12:28

Unfortunately, we can't reproduce the issue on the latest version of SDAC 8.0.5 . To investigate this behavior of SDAC, please compose a small sample demonstrating the issue and send it to us including database objects for creating scripts.

so-photo
Posts: 5
Joined: Thu 26 Apr 2018 11:11

Re: A request to establish a connection with the transaction manager was denied.

Post by so-photo » Wed 30 May 2018 15:37

Thanks for the answer.

I think that the environment is not so easy to portray. The server is running on a VM Cloud, with about 1000 databases.

Is there any information from you about the exact connections of the Lock Mechnanisms? Or a white paper for a multiuser environment? The help in the net is good and nice, but provides little coherent information about the sdac.

Greets...

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: A request to establish a connection with the transaction manager was denied.

Post by Stellar » Wed 11 Jul 2018 12:11

You can find the demo project in the directory %SDACDemos%\. %SDACDemos% is the path to the installed demo projects on your computer.
The Lock tab shows a sample of how to lock a record.

For more information on the LockMode, please refer to our online documentation:
devart.com/sdac/docs/devart.sdac.tmsquery.lockmode.htm

Post Reply