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

Good and bad is not an absolute. It is, from my experience, a question of trial-and-error. I have found, in general, that the ones from Oracle are far better than the ones from Microsoft.

Daniel A. Morgan

Niall Litchfield wrote:

> Do you have a reference web site for good/bad oledb driver versions? It
> would help me with my other hat as IIS sysadmin. I am interested only on
> Oracle/access providers I don't care about SQL server
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3ABD4CDB.3D15F5C5_at_exesolutions.com...
> > From my experience CORBA outperforms COM+.
> >
> > But COM+ does work with Oracle.
> >
> > Be careful however with respect to OLEDB drivers. Some are bad ... and
 some are
> > far worse. What doesn't work with one may work with another.
> >
> > Daniel A. Morgan
> >
> >
> >
> > Silent Sadness wrote:
> >
> > > 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 Mon Mar 26 2001 - 19:53:33 CST