Method ~ of ~ failed when using MTS
Hello,
We are using MTS 2.0 with Visual Basic 6.0 to Access ORACLE 8.0 Database using 3 tier architecture. The System has been deployed over a Virtual Private Network (VTN). We are repeatedly getting the Error "Method ~ of Object ~ failed" and the MS DTC service automatically stops when we try to access the business layer.
This worked fine over a local LAN. The Problem is occurring in the live environment where is a lot of Data on the server and the system has been deployed over the VPN.
We were also getting the error "Failed to enlist on calling objects transaction". However this was rectified by increasing the Transaction Timout Interval in MTS.
Could you please suggest some solution for the above ASAP.....
Thanks
Re: Method ~ of ~ failed when using MTS
if the business layer components method has got Recordset as the first parameter this problem occurs. change the ordinal position
of the recordset parameter and proceed. This reported bug by MS, refer to MSDN online