Re: ODBC/OLE DB Connection Pool - 1 attachment

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


Date: Sat, 27 Nov 2004 23:02:04 +0000 (UTC)

Bob Barrows [MVP] (reb01501@NOyahoo.SPAMcom) writes:
> Erland Sommarskog wrote:
>> Well, in VB it as easy as:
>>
>> Publlc Function Button1_Click () As
>> Dim cnn As new ADODB.Connection
>> ...
>> Set cnn = Nothing
>> End Function
>
> This does not shut off pooling. Where did you get this idea? Closing thie
> connection in this case simply released it to the pool

I got this idea from testing and observing. Run the attached project, and
fire up SQL Profiler. Notice that each time you click the button you get
an Audit Login and Audit Logout event. There's definitely no pooling going
on.

Of course, this presumes that you don't have any global connection anywhere.
(If you move the declaration of cn to form level, you do get pooling.)

-- 
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
begin 644 namedparamtest.zip
M4$L#!!0````(`$BC:S$Z27'_=00``$$-```<````;F%M961P87)A;71E<W0O
M861O<V%M<&QE+F9R;:U6;6_B1A#^'BG_8<2'.Z+F$*^Y]*Y42H"T2!QP(4T^
M1HL]X.T9K[5>$_CWG5VOUW:..%552QC8>7_FF;$?)_>KZ6(.@U:[?7YVBUL>
MP>-MZT[('>A;!\[/`&#$8L5%!/DUI$_#R!N9/.08J3^1;P.5RP?M[J`DG.%&
M%<97[9+H0<0EO[U^V>R)^RIPLO[5=68XX]$/,N/>&PFM/!9BD4\U(2,L'%<]
MKQ23ZJ]X*1)N2C8I`7Q\XI$O7A(8XX:EH3*Z#J\'/*A;<8!%JN)499C154K`
M!>IV?QWD\@*30MZST-#UC>)PJA1+XD\=RN5!II@K/;#U-/+Q4/;A`NB\H'09
MF)@O$K:+0VQMY*'QI=UNNXA%)PK][J#KY"70G+S?M@5-(K^*RL*0YC95BG!<
M2K'G/DH'SDE.K;[/YJ/9M%&'8.^SJZ]2N15WZM#M]HM:3P#7KP6B7XM#I]?[
M7W%8S";CVUH@NH-:(%RV_P&(7AT0UX7M(PO3G)ZY^">*GD2KVWD#K7R65BCW
M)9C>8<+)&DO,/56D8\K),6F&@O;$A>O`*23ZU_64Z`_>*'(D=CL6^983]E^G
MGA/W:51+A_X[BZ4\YR?0J%T"G7X]^:_?*G3&UAB"N;]37M;O?TOXD_V^JB=U
MM[;"^BU7*=#<;I22?)TJI#*?YVR'I.<>017A'Z%8LU"KK&+F:;T[%B;X2FLD
MD2FV#M^2+R7ZZ(6,OJ8^Z6035E&9'&*1H%\XR#8/T'G(/4X/K:S$\[.EY'M&
M1JMT[=CW3$]<[T?S0FN-^0Z\"&X2F.,+W(P78\W9*$)/.[3RG?]:P3C*I#*I
M"N_1$])/4&7B3>B'@MI`.IG\CF-H36,F&;UYD&BI?Z%">9D==D\=]BJ'U@5M
MV9626D)?/-K:I,21A>JHCQ^9Y"PRD'P$6QJD":F""@@8NX"-)[VO6^=G7M1R
MVWL(T^FFF?]MMB]:9A5>EE;W9?$X(TRS5P.SW311&EG@58P>WQS!<]A"8O(%
M^K6(,0(J*A`^1<]+&N:C,FS`![LE,[<?H/%UK#G$$ASN6$)H?"66T+?_7#1O
M>,2D88HQ_JU;FPX2!C$PRL>T$L3Z;XW+1DB#2J($T4_;>.BG$BDM;4),:-V0
M\ST682A/CXBB1987>>E)_!Q@&',]GHVJQC'6[&?^:.>O3"@"V,M4]/CXKLN)
M&P`M*XZ)9AN)2?#ZO-FQ#3()'!/?PI38/DP.Z.DALG5?@B[>$%0%4J3;`&3.
M7V(=-4B9'M&[GJ270@N#R4K'M=[R0>*:;]-(X5;3\RG@-.-SH?5;D\5=-I*T
M.&#"O,`-QC32<C,52;Z8`*HL*O^CYO_VZ7=-"6?6Y!>%)2=]#K_D#[VYMK&Q
MLI,ZU_OU2,XVF9YV9%<E1?HF]JA]45VH1U^#.4?BB!+@A;2-"N!@C<0CA"TJ
M@YY$E<I(&QBF9:_.<='*\S.ZC;0/[;:V<J+)ENR`4J#0+UP%UCLUU,<OH&&A
MQM"8&N);IZYGU(S`[`A+YI^.HO*)V?]Z<^J?_P!02P,$"@``````2*-K,0K;
M"V`&````!@```!P```!N86UE9'!A<F%M=&5S="]A9&]S86UP;&4N9G)X!51E
M>'0Q4$L#!!0````(`$BC:S$"K;]U^@$``!H#```<````;F%M961P87)A;71E
M<W0O861O<V%M<&QE+G9B<%U238_:,!"](_$?(KBTE4#Y@&6IE`,DI$7:`&HH
M6ZGIP4DFX%U_1+;#PE;][[5CNE6;@S7O36;>S+/WUP;"U07ZO2]0@P!60O@A
M__33=5W?G03N2`>W(_H3V6]R]VOHC]VA.XP^YH_K3;Q]S')YE0IHX.=259R`
M/U:D&&X?5LZB59PBA3G[7\E?S*;>_"X:Q?/5<C3Q_/EH>>\&HWG@!?XLF?GQ
M-#)*]U9I)_A1(.HDF(#,(TXI9S>0=>(YJGA.I3Z]Z;@B9)CB4G#):^4L2H7/
M\,V)D4+.MGB"4DE'=W8><"&0N/9["1<TU*42T8;`N!:TW\L4$JIMPH%)>H-^
MSX@B5@5^.-!H@RB$`SV6:6?2GX$T$6<*+FH=AP/75C1Z^8)`RBNP7(J>N#B`
M"#T=8V9CU[ASQE+[=(/&N#4K!5!@ZL9E(,X@LK9IN%#=[H;525/7:;&K'6LE
MB)[4R<S$0C[SXVT83+J[V)O;UZ7;1F&*7__A$G3F8J=%<4OU=N\4?6_H2"]P
MP/`20]$>UZSFAMSP!<%(8G8T:,E;5LGH!.5SUUS/6A/^\D8D9,<Q4W]QO#Z\
M@:],F'*HDEVWJC&_,ZW+(:7`)*U1"F%FX_U)`*IV(.RM&BI%ETU+"TW5-BN-
MT_W>]S1S]@(QB4JSKF/-_&&=UD]3@#R9/W\#4$L#!!0````(`%:B:S%?F'FQ
M*@```#$````<````;F%M961P87)A;71E<W0O861O<V%M<&QE+G9B=W/++\HU
M5+!5L##443`#8G-#(R!A;**CH*-@9`3!)N;&0$E3,QT%9UXN`%!+`P0*````
M``!(HVLQ````````````````#P```&YA;65D<&%R86UT97-T+U!+`0(4`!0`
M```(`$BC:S$Z27'_=00``$$-```<``````````$`(`"V@0````!N86UE9'!A
M<F%M=&5S="]A9&]S86UP;&4N9G)M4$L!`A0`"@``````2*-K,0K;"V`&````
M!@```!P``````````0`@`+:!KP0``&YA;65D<&%R86UT97-T+V%D;W-A;7!L
M92YF<GA02P$"%``4````"`!(HVLQ`JV_=?H!```:`P``'``````````!`"``
MMH'O!```;F%M961P87)A;71E<W0O861O<V%M<&QE+G9B<%!+`0(4`!0````(
M`%:B:S%?F'FQ*@```#$````<``````````$`(`"V@2,'``!N86UE9'!A<F%M
M=&5S="]A9&]S86UP;&4N=F)W4$L!`A0`"@``````2*-K,0``````````````
M``\````````````0`/]!AP<``&YA;65D<&%R86UT97-T+U!+!08`````!0`%
+`&4!``"T!P``````
`
end