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!
A request to establish a connection with the transaction manager was denied.
Update: A request to establish a connection with the transaction manager was denied.
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????
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????
Re: A request to establish a connection with the transaction manager was denied.
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.
Re: A request to establish a connection with the transaction manager was denied.
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...
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...
Re: A request to establish a connection with the transaction manager was denied.
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
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