RE: Connection Pooling

[Darren Hill]

I'm getting ... 

Error connecting: 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. 
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code. 

Exception Details: ByteFX.Data.MySqlClient.MySqlException: error
connecting: 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.

Source Error: 

An unhandled exception was generated during the execution of the current
web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below. 


Darren Hill
darren@stripped
Tel: [phone] ext. 2
Toll Free: 866-410-1154 ext. 2
Fax: [phone]

Darren,

I suspect that I am having the same problem as I am experiencing 
timeouts. I have tried both the ByteFX and the beta 1 release. How would

I confirm that the problem is connection pooling though .. the error 
message I get is "unable to read the transport protocol".

thanks
  Guy

-----Original Message-----
From: Darren Hill [mailto:darren@stripped] 
Sent: October 26, 2004 4:50 PM
To: dotnet@stripped
Subject: Connection Pooling

Hi all,
 
I'm still using the old ByteFX version and have run into Connection
Pooling problems.  It seems that the connector is not reusing open
connections, and finally causing time-outs.  Is there a resolution, or
could someone point in the right direction?  
________________________________________
Darren Hill
darren@stripped
 
Ormac Inc.
162 Guelph Street, Suite 215
Georgetown, ON L7G 5X7
Tel: [phone] Ext. 2
Fax: [phone]
www.ormac.com
________________________________________