Re: Is MTS reliable with Oracle?

Strange. We are coming to the end of a claims system based around a workflow.
Anyway - our site is ORACLE (on VMS) and NT. To be honest we haven't had many problems with ORACLE, the biggest headache is the fact that nobody knows for sure if ORACLE is XA compliant on VMS. Several fixes modify the VMS lock manager - so everything seems okay.

Make sure you use the MS OLEDB driver for ODBC. Don't use OLE-DB for ORACLE - we couldn't get it to work.

Faizul Hamid <dsstest_at_yahoo.com> wrote in message news:8abfcs$hb3$1_at_news.gov.on.ca...
> I am interested to hear from those that have Microsoft Transaction Server
> working with Oracle 7.3/8 in a production environment. I have followed
 the
> knowledge base articles and was successful in getting MTS to work with
> Oracle, and more importantly to roll back transactions.
>
> However the MTS/Oracle fix is kludgie at best; in addition I have read in
> the newsgroups of people with problems in a production environment
 including
> hanging problems. Oracle is our standard database, and we are forced to
 use
> it, else we would implement SQL Server and save ourselves the headache :)
>
> The application we are developing is a workflow and document management
> application, with over 1,000 users. Currently we are in the
> development/prototyping phase, utilizing ActiveX components in a web
> browser.
>
> So I would like to know how reliable the two products are together, and
 the
> specific configuration details including: Operating System, Oracle version
 +
> patches, Oracle parameter settings, type of application, number of users,
> etc.
>
> Note: for the flamers of this architecture, please suggest an alternative
 if
> criticising this one.
>
> Thanks
>
> faizul.hamid_at_moh.gov.on.ca
>
>
>
>
Received on Sat Mar 11 2000 - 00:00:00 CST