Tom Knowlton
asked on
Timeout error - MySQL
{"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."}
Error Code: -2147467259 (is there a list of error codes and troubleshooting error codes, somewhere?)
Here is the connection string:
<add name="leadcollatordb" connectionString="server=1 0.1.1.160; uid=root; pwd='<<hidden>>'; database=leadcollator_dbo; default command timeout=28000;"/>
Error Code: -2147467259 (is there a list of error codes and troubleshooting error codes, somewhere?)
Here is the connection string:
<add name="leadcollatordb" connectionString="server=1
What version of MySQL connector Net are you using? there was a bug for this that was fixed http://bugs.mysql.com/bug.php?id=29409
ASKER
How can I find out what version of MySQL connector I am using?
ASKER
6.0.4?
mysqlconn-version.jpg
mysqlconn-version.jpg
yes, that's the one, hmmm 6.0.4
try to run it without the timeout setting
try to run it without the timeout setting
ASKER
removed default timeout from the connection string.
Still get:
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.
Still get:
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I may try that at some point.
I discovered that I had been neglecting to close the connection.
I discovered that I had been neglecting to close the connection.
give me a sec