Solved

What does "A Request to establish a connection with the transaction manager was denied" mean

Posted on 2014-01-23
5
496 Views
Last Modified: 2014-02-01
Hello I have the above error when trying to ApplyUpdates() to a ClientDataSet in Delphi XE5 using a Datasnap server client connected to a MS SQL Server database.  Can anyone explain what this means and how I might fix it
0
Comment
Question by:cliveMM
  • 3
5 Comments
 
LVL 36

Expert Comment

by:Geert Gruwez
ID: 39806217
is there a local service on the windows pc ?
Distributed Transaction Coordinater

Is it running ? or enabled to run ?

Having it running, or restarting it may solve the problem
0
 

Author Comment

by:cliveMM
ID: 39810229
Hi Geert, thank you for responding.  I don't think its anything to do with the local pc as the App is running on an Android tablet and the message occurs on the datasnap server.
0
 

Accepted Solution

by:
cliveMM earned 0 total points
ID: 39813044
I have found the cause now, I changed the primary key field on the table from a BigInt to Int and the problem disappeared.
0
 

Author Closing Comment

by:cliveMM
ID: 39826107
Self Answered and put on line to assist oters
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
SQL Server Log File Space 6 33
tidtcpserver connection lost handle 2 42
SQL Split character from numbers 3 16
Azure SQL DB? 3 15
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now