Re: Is the use of Oracle and COM+ too massive a risk?

From: Egbert Nierop <egbert_nierop_at_nospam.com>
Date: Sat, 24 Mar 2001 23:26:38 +0100
Message-ID: <#5K$EGLtAHA.1992@tkmsftngp03>

I've been developing COM objects that ran in MTS (nt 4 land) with VB Com objects. They worked well but I did not use transactions. When I needed them I cared for my 'own transactions' (no automatical enlistment).

NT 4 is by nature more reboot intensive but on COM+ support has only gone better. About transactions, I have no experience on that.. Others might comment.

--
Session management for webfarms:
http://www.nieropwebconsult.nl/asp_session_manager.htm
"Silent Sadness" <ap_osborne_at_hotmail.com> wrote in message
news:985463669.22477.0.nnrp-13.c1ed9f09_at_news.demon.co.uk...


> Having read some newsgroup articles I have rapidly come to the conclusion

> that a lot of people are having significant problems when deciding to

> develop services in COM+ that transact against an Oracle database

 (sometimes


> even SQL server).

>

> Scenario

> Given that we can setup the environment correctly; will not be running in

 a


> distributed transaction environment; will utilise the Microsoft OLEDB

> provider (minimise risk, maximise support option); but will be dealing

 with


> significant volume.

>

> Question

> Can I rely on this service to be up 24*7 or are the bugs that have been

> noted been resolved or am I  going to be forcing me to reboot my NT 2000

> box(es) and run out of client connections on my oracle database (Unix

 land)?


>

> Basically is this route even vaguely worth the effort for the supposed

> reward.

>

>

>

Received on Sat Mar 24 2001 - 16:26:38 CST