Thx for the reply

Unfortunately COM+ is an integral part of the solution, so not really an
option to take that out.

Regarding the extra dispose: according to some other replies, close alone
might in some instances not do the trick, and it would be better to do
dispose as well.  There are a couple of functions to do queries (some retuns
datasets, other XML string, other none) and two of them had no dispose in,
which was then added.  It is hard to measure the exact impact of this
change, but it did seem to make a difference.  We did do a close in those 2
places, so if you are correct, I don't know why it makes a difference.

The funny is that fact that it seems to be process related.  It is a large
project, consisting of many modules, and this function uses nearly every
available class in there, so it takes a while to implement any change and
retest.  We have done a couple of changes to the COM+ setup however, and
should be ready for testing again later today.  Will keep you posted if we
find the issue

JC Oberholzer


-----Original Message-----
From: Heath Ryan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 30, 2003 12:34 PM
To: [EMAIL PROTECTED]
Subject: Re: [ADVANCED-DOTNET] The timeout period elapsed prior to obtaini
ng a connection from t he pool.

 JC wrote:
>The data access class always opens a connection, does the query and
>closes
>the connection again (thx to you guys, we now have a couple of extra
>dispose statements in there as well, made some difference - thx)

I cannot see why this should have made any difference,
since Dispose is calling Close, doing nothing extra!
(this is based on Reflectors info on SqlConnection v1.1)

Correct me, if i am wrong here...

>Environment is: COM+ on winXP.  SQL 200 on Win 2000.  Development in
>Vb.NET
>using the data.sqlclient classes to connect and do queries.  The COM+
>packages are deployed as "library"

It is by any chance possible to not use COM+?
Lets see if the problem lies within COM+...

// Ryan

-------------------------------------
The information included in this message is personal and/or confidential and
intended exclusively for the addressees as stated. This message and/or the
accompanying documents may contain confidential information and should be
handled accordingly. If you are not the intended reader of this message, we
urgently request that you notify Centric immediately and that you delete
this e-mail and any copies of it from your system and destroy any printouts
immediately.
It is forbidden to distribute, reproduce, use or disclose the information in
this e-mail to third parties without obtaining prior permission from
Centric. We expressly point out that there are risks associated with the use
of e-mail. Centric and the companies within the group shall not accept any
liability whatsoever for damage resulting from the use of e-mail. Legally
binding obligations can only arise for Centric by means of a written
instrument, signed by an authorized representative of Centric.
-------------------------------------

===================================
This list is hosted by DevelopMentor(r)  http://www.develop.com
NEW! ASP.NET courses you may be interested in:

2 Days of ASP.NET, 29 Sept 2003, in Redmond
http://www.develop.com/courses/2daspdotnet

Guerrilla ASP.NET, 13 Oct 2003, in Boston
http://www.develop.com/courses/gaspdotnet

View archives and manage your subscription(s) at http://discuss.develop.com

The views expressed in this e-mail are, unless otherwise stated, those of the author 
and not of SDT or its management. The information is confidential and is intended 
solely for the addressee. All reasonable steps are taken to ensure the accuracy, 
integrity and confidentiality of information. No liability or responsibility is 
accepted if information is corrupted or does not reach its intended destination. This 
email message has been scanned for viruses and cleared.

===================================
This list is hosted by DevelopMentor�  http://www.develop.com
NEW! ASP.NET courses you may be interested in:

2 Days of ASP.NET, 29 Sept 2003, in Redmond
http://www.develop.com/courses/2daspdotnet

Guerrilla ASP.NET, 13 Oct 2003, in Boston
http://www.develop.com/courses/gaspdotnet

View archives and manage your subscription(s) at http://discuss.develop.com

Reply via email to