Devart Forums

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!

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????

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.

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...

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