ASP---Stored Procedure---MTS

Results 1 to 3 of 3

Thread: ASP---Stored Procedure---MTS

  1. #1
    Rob Guest

    Default ASP---Stored Procedure---MTS

    Hello, <BR><BR>I&#039;ve read articles that say the only way connection pooling truly works (ie, reusing existing connections) with ASP&#039;s that use Stored Procedures, is by using Microsoft&#039;s Transaction Server (MTS) inside the ASP. <BR><BR>1) Is that a true statement? <BR><BR>2) I&#039;ve searched long and hard on the web (and this site) but I can&#039;t find any EXAMPLES as to how to call MTS inside your ASP when using stored procedures. I would think this would be a very important topic, but nobody seems to discuss it much. <BR><BR>Any help with examples, advice, opinions would be appreciated. Rob <BR><BR>PS...This may be an idea for a 4guysfromrolla article?!?!

  2. #2
    Mr. Bigglesworth Guest

    Default RE: ASP---Stored Procedure---MTS

    I&#039;ve never heard of that in my life.<BR><BR>Here&#039;s my understanding of MTS.<BR><BR>MTS has many useful built in features and interfaces you can use for your COM components. <BR><BR>Connection pooling only truly occurs w/ components written in even VB COM cannot be pooled in MTS (COM+).

  3. #3
    Rob Guest

    Default RE: ASP---Stored Procedure---MTS

    Check out the "Implement database connection pooling" section on<BR><BR>Thanks, Rob

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts