Re: Is MTS reliable with Oracle?

Hi Michael, thanks so much for your real world advice.

Just to confirm, you are suggesting using OO4O data access object layer (DAL) rather than ADO, to provide greater stability with Oracle. From my understanding using this DAL will provide better integration with the Oracle objects and procedures.

So the OO4O DAL will work in MTS objects without transaction support, and to confirm, code the transaction support in the objects themselves or using stored procedures in the database?

Any other wisdom's you can provide will be appreciated. For example does the Oracle services for MTS work only for Oracle 8i? Is there any documentation on coding Visual Basic objects to make use of this service?

It has been very difficult to access any real world experiences with Microsoft Transaction Server and Oracle. In addition we have enterprise support with both Oracle and Microsoft, and have so far not received much help. In fact one Microsoft support rep did not find the KB that describes configuring MTS with Oracle, only when I provided the specific KB number was it miraculously found!

Thanks

Faizul

Michael D. Long wrote in message ...
>
>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
Received on Wed Mar 15 2000 - 00:00:00 CST