Transaction trouble around Exchange and others 
Author Message
 Transaction trouble around Exchange and others

Can anyone help

Win2k sp2/VB6/COM+/MSMQ2/SQL2k/E2k sp1

From a standard exe I create a  VB6 component that requires transaction
Within this component
I select from SQL2k, enabling commit at the end of proc
I open an MSMQ queue and receive current within MQ_MTS_Transaction, enabling
commit at end of proc
I open a CDO Ex object, ie CDO.datasource.open, enabling commit at end of
proc
I send the CDO message, CDO.send,  enabling commit at end of proc
I write to an MSMQ,  enabling commit at end of proc
I complete the transaction using set complete

First problem is I create 2 transactions, second one of them aborts, thirdly
I get an rpc error after the set complete coming back to the exe.The error
which is an assertion failure, !m_punk on MS says I need the latest service
pack, which on Win2k I have. The cdo message is sent, the queue isnt
received from nor written to, ie successful rollback

 If I dont open a cdo message but just create a fake one, I dont get the rpc
error , which would appear to say that the implicit connection for exchange
is creating some havoc, starting a new transaction that then cant be
completed.

My next move is to move the opening the cdo message to a class that requires
no transactions but this is just a hit in the dark, anyone got any clues on
this one

TIA



Tue, 31 Aug 2004 07:16:31 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Using VBScript to copy folders around in Outlook w/ Exchange

2. trouble with transactions

3. Trouble with data exchange between Project and Excel!

4. Trouble connecting with Exchange using VB 5

5. Microsoft Exchange Trouble

6. Trouble connecting with Exchange using VB 5

7. To Transaction or Not to Transaction that is the question

8. ADODB TRANSACTION ADO ERROR No Transaction is Active

9. Why to use COM+ transaction and not just SQL Server transaction

10. Reqiured Transaction and Required New Transaction

11. Cannot connect to the transaction manager or the transaction (-2147168229)

12. ADODB TRANSACTION ADO ERROR No Transaction is Active

 

 
Powered by phpBB® Forum Software