Hi everone,

I'am new to VB and Com++. I'm cofusing.

1. Do I need to use both ADOConnection Transaction and ObjectContext Transaction.

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!

Steve,
If you are going to place your VB components in COM+, then use the
ObjectContext transaction.  For an example, see
http://msdn.microsoft.com/library/en-us/cossdk/htm/pgprimer_4p4i.asp

You can also manually control the COM+ transaction using the
TransactionContext object.  For more info, see:
http://msdn.microsoft.com/library/en-us/cossdk/htm/transactioncontext...

If you are NOT going to place your VB components in COM+, then use
the ADO Connection transactions.  For more info, see
http://msdn.microsoft.com/library/en-us/ado270/htm/mdcontrxproc.asp

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

thank you for your info. I will review these links. One more question .

Right now my VB component only uses Cnn.transaction and declare as "NotAnMTSObject". I am running this component in Com+ enviroment.
If I switch to use ObjectContext trans and declare as "Required Trans", will the peformance be suffer because the overhead of ObjectContext Transaction?

thank you for your advice

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

thank you for your info. I will review these links. One more question .

Right now my VB component only uses Cnn.transaction and declare as "NotAnMTSObject". I am running this component in Com+ enviroment.
If I switch to use ObjectContext trans and declare as "Required Trans", will the peformance be suffer because the overhead of ObjectContext Transaction?

thank you for your advice

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Of course that is another option you can use...  ;-)

Good question!   I don't have actual performance numbers between the two.  May be
someone else in this newsgroup can provide these...  

IMHO - For applications that need to scale, you should use the COM+ ObjectContext
Transactions.  For small applications, the Connection Transactions can actually be faster
than the COM+ Transaction.

You might want to ask this question over in the COM+ newsgroup.
microsoft.public.platformsdk.complus_mts

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

Carl,
    I may just be confused but another take on this is a set of rules like
this for DB components:
        1) Always register with COM+
        2) use ADOConnection Transaction to control transactions in a single
             DB instance
        3) use  ObjectContext Transaction to control two phase commit across
multiple DB instances

what say U?

http://msdn.microsoft.com/library/en-us/cossdk/htm/transactioncontext...
sp

Interesting...     Somehow #2 doesn't sound correct....

I sure would be interested in hearing what others in this newsgroup say about this issue.    

--

Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com

I know that #2 is contra receive wisdom but I have seen reference in a
couple of places asking why should we incure the overhead of COM+
transaction which is just going to turn around and use SQL Server (or
whatever) native transaction support.  In that case why not just code the
transaction into either the ado connection or just use SQL statements to set
up the transaction?