Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP General > How to using connection pool technlogy in ASP

Thread Tools

How to using connection pool technlogy in ASP

Utada P.W. SIU
Posts: n/a

Reply With Quote
Egbert Nierop \(MVP for IIS\)
Posts: n/a
"Utada P.W. SIU" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks~~

The magical thing isn't it? If you can pool, your app will rock
ASP itself, does not use pooling. Only COM+ components written using C++ or
a .NET language ca be pooled. Note that pooling should not be a -target- but
a solution, if you really need it for specifici reasons. eg:
1) you need to cache specific data.
2) you have a specific driver that does -not- support database resource
pooling (ado does support!).
3) etc

compatible web farm Session replacement for Asp and Asp.Net

Reply With Quote
Bob Barrows [MVP]
Posts: n/a
Utada P.W. SIU wrote:
> Thanks~~

You should be asking how NOT to use connection pooling. In ASP, connection
pooling is used automatically, without the developer having to do a thing.

Now, mind you, there are things a developer can do to disable connection
pooling, such as:

- failure to use an explicit connection object to open recordsets or execute
commands. This syntax:

set cn=createobject("adodb.connection") <some connection string>
set rs=createobject("adodb.recordset")
rs.Source=<some query string>
rs.ActiveConnection = cn

will cause a second connection, using the connection string from cn, to be
opened and used to open rs. To prevent that, you must use the Set keyword:

Set rs.ActiveConnection = cn

- use of the OLE DB Services attribute in your connection string to disable

- failure to close and destroy connections when you are finished with them

Here is some more information:;en-us;Q176056;en-us;191572;en-us;324686

Bob Barrows

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the

Reply With Quote
Dave Anderson
Posts: n/a
Bob Barrows [MVP] wrote:
> rs.ActiveConnection = cn
> ...will cause a second connection, using the connection
> string from cn, to be opened and used to open rs. To
> prevent that, you must use the Set keyword:
> Set rs.ActiveConnection = cn

Or use JScript, as the above is the only possible syntax for assigning the
ActiveConnection property in JScript.

Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How include a large array? Edward A. Falk C Programming 1 04-04-2013 08:07 PM
does python have a generic object pool like commons-pool in Java Rick Lawson Python 8 07-16-2009 11:25 PM
PIX 501 issue routing between VPN pool and local pool eostrike Cisco 3 10-24-2008 09:43 PM
F--k Creative Technlogy Ltd for their stinky diarrhea kakaa foam of sample playback MIDI synths. I want Creative Music Synth [220] Radium Computer Information 0 01-28-2007 01:21 AM
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Guoqi Zheng ASP .Net 4 06-03-2004 06:39 PM