I think it' s more to do with the MySQL ODBC driver than the ASP code. Right now, there are 19 connections.
You can also get these errors if you send a query to the server that is incorrect or too large. The last time this happened, there were a lot of connections. We never see this with PHP code we also have running under the same IIS server whereas I believe the ODBC driver connects once , however PHP re- connects each time it is ran stays connected.Max_ allowed_ packet= 64M Adding this line into my. 9- standard- log] MySQL server has gone away Done - press Enter.
I thought that the # of connections might be a problem at some point too. We also have a long- standing issue with this problem ( " MySQL server has gone away" ) during shortish periods of inactivity using the ODBC connector.
- - - - - Seems MyODBC 3. Error hyt00 mysql odbc 3 51 driver mysql server has gone away. 9- standard- log] MySQL server has gone away Connection state ' Open' - executing query.
So after 8 hours idle, my sql server closed connection and in my software i get the message server has gone nnection Timeout Access [ MYSQL] [ ODBC MYSQL 5. 1 Driver] [ mysqld- 5.
45- community] Mysql server has gone away ( # ).
ERROR [ HYT00] [ MySQL] [ ODBC 3. 51 Driver] Lost connection to MySQL server during query.
11/ 29/ 05: 17PM Re: ERROR [ HYT00] [ MySQL] [ ODBC 3.
11/ 30/ 10: 33AM Re: ERROR [ HYT00] [ MySQL] [ ODBC 3. 51 Driver] Lost connection to MySQL. Error: ERROR [ HYT00] [ MySQL] [ ODBC 3. 51 Driver] [ mysqld- 4.