Re: ORACLE - MS MTS/DTC performance problem

• 1. MTS will only work with Oracle 7.3.3 client to talk to Oracle 8 *
• Have you tried this? *
• 4 Update Oracle Client Software Registry Keys
• If you are using Oracle 7.3 Client software, you may skip this step. *
• If you are using Oracle 8 Client software, you must modify the values of two registry keys. Under the HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\Transaction Server\Local Computer\My Computer registry key there are two string-named values that specify the names of the Oracle 7.3 Client software DLLs.
• OracleXaLib "xa73.dll"
• OracleSqlLib "sqllib18.dll" *
• Change these values to specify the names of the Oracle 8 Client software DLLs.
• OracleXaLib "xa80.dll"
• OracleSqlLib "sqllib80.dll"
• (Microsoft Transaction Server Using Oracle Databases with MTS
• Version 2.7 June 03, 1998) *
• I' ll be tryinG MTS & Oracle as soon as my hardware arrives..please keep me appraised of any developments. *
• Thanks, *
• Ron

Hong Yew wrote:

> Willian,
>
> We are also testing for exactly the same thing. According to MTS FAQ, we
> found a few unexpected problems:
>
> 1. MTS will only work with Oracle 7.3.3 client to talk to Oracle 8
> 2. OCI (which is used by Oracle OLE 2.2) does not work in connection
> pooling. Could this be
> the reason it is slowing you down? So we're stuck with RDO/ODBC.
>
> The reason we turned away from ODBC to OCI was the performance. Now,
> looks like we may have to go back to ODBC to take advantage of connection
> pooling. We are planning to pilot some local MTS performance test at this
> stage before we try DTC.
>
> If you don't mind we could discuss our findings on the next few days. If
> you've made any progress in the next few days, do you mind letting me know
> at Hong_Yew_at_nag.national.com.au ?
>
> Regards,
>
> Hong Yew
>
> Oracle wrote in message <6r9upk$g10$1_at_trex.antw.online.be>...
> >Hi,
> >
> >On a pilot project we are using Oracle 8 for NT together with Microsoft
> >Transaction Server 2. The database is running on a separate machine.
> >Database calls from COM components running in MTS to the database are slow.
> >This becomes even worse when the component is enlisted in a transaction.
> >
> >Please Help,
> >
> >Thanks
> >
> >William
> >
> >
Received on Tue Aug 18 1998 - 17:38:48 CDT