"A connection with the transaction manager was lost"
Posted: Mon 29 Dec 2008 15:16
SDAC 4.70
Delphi 2006
I am trying to follow the advice given for my previous issue in this forum (Simple multi-user problem locks/transactions)
I have the following code:
txnNextCB.AddConnection(qryNextCB.Connection);
txnNextCB.StartTransaction;
qryNextCB.open;
where txnNextCB is a TMStransaction and qryNextCB is a TMSquery.
txnNextCB has been put on the form with all the defaults apart from its name and this is the first time it is referenced - no other connections have been added.
When I run the code, I get:
"A connection with the transaction manager was lost"
If I comment out the code referring to the transaction
// txnNextCB.AddConnection(qryNextCB.Connection);
// txnNextCB.StartTransaction;
qryNextCB.open;
the query runs okay indicating that qryNextCB.Connection is connected and works.
What am I doing wrong?
Delphi 2006
I am trying to follow the advice given for my previous issue in this forum (Simple multi-user problem locks/transactions)
I have the following code:
txnNextCB.AddConnection(qryNextCB.Connection);
txnNextCB.StartTransaction;
qryNextCB.open;
where txnNextCB is a TMStransaction and qryNextCB is a TMSquery.
txnNextCB has been put on the form with all the defaults apart from its name and this is the first time it is referenced - no other connections have been added.
When I run the code, I get:
"A connection with the transaction manager was lost"
If I comment out the code referring to the transaction
// txnNextCB.AddConnection(qryNextCB.Connection);
// txnNextCB.StartTransaction;
qryNextCB.open;
the query runs okay indicating that qryNextCB.Connection is connected and works.
What am I doing wrong?