I agree with Rick here, why are you using COM+/MTS in the first place, especially if you are using TADO to bind data to the UI. This will result in a stateful application, and is not recommended under COM+/MTS.
>I don't use ado directly because the TADOxxx clases encapsulate a lot of thing (for example, binding to the UI,etc...)
>
>Playing a lot with the config, a see it:
>
>- The recordset using batch locking, client-side recordset and is disconnected. All recordset is return from a sp.
>
>- If you set Marshall options to adMarshallAll, that return record, but in large data this take forever (when normal is <10 sec)
>
>So i think, the pronlem is passing the data inter-treads. DLL is compiled multi-trhead
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer