Re: Is MTS reliable with Oracle?

As I repled via e-mail:

No, OO4O will not work in an MTS transaction.

Treat distributed transactions like the plague unless you are truly posting a single transaction to multiple databases. In the best of circumstances, a distributed transaction costs roughly 5x that of a connection based transaction.

When I say use MTS as an object broker, I simply mean to mark your components as 'No Transactions' and explicitly code your own transactions.

Mike

Faizul Hamid wrote in message <8aj1hc$lav$1_at_news.gov.on.ca>...
>You mentioned using Oracle objects for OLE, will this data access method
>work in an MTS transaction?
>
>I have tried so many combinations that I can't remember the details of them
>all, however I was only successful in rolling back a transaction using the
>Microsoft Oracle driver, and the registry patches mentioned in the KB.
>
>Also, I would appreciate some additional details on using MTS just as an
>object broker, I am not certain what this means.
>
>I really appreciate your other advice. FYI, we will have approximately
 1000
>users, however I anticipate < 100 simultaneously.
Received on Tue Mar 14 2000 - 00:00:00 CST