Re: ODBC/OLE DB Connection Pool

From: Erland Sommarskog (esquel_at_sommarskog.se)
Date: 11/25/04 

Date: Thu, 25 Nov 2004 23:02:39 +0000 (UTC)

Bob Barrows [MVP] (reb01501@NOyahoo.SPAMcom) writes:
> If you read Stuart's post carefully, you will see that you do not have
> to do anything to turn Session pooling on. It's on by default. You have
> to do extra work to turn it off.

Well, in VB it as easy as:

  Publlc Function Button1_Click () As
  Dim cnn As new ADODB.Connection
  ...
  Set cnn = Nothing
  End Function

And if there is no global ADODB.Connection, there will be no pooling.
(Which Stuart also discussed in his post.)

If the above is possible to do in ASP, I don't know. 

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp