We are running MySql 4.1 and PHP 5.0.4 and IIS 6 on a Win 2003 Server.
The mysql_connect() function seems to be timing out at intermitant intervals.
We can run a number of sql queries for sometimes 10 to 15 mins, then mysql_connect() returns false and we get a #256 error.
We have set the IIS timeouts very high, and the PHP session timeouts to many hours.
Whenever the connection fails we can still use the same My Sql user ID in a mysql command line session and access the database.
We then wait for say 10 mins, and rerun the PHP scripts and it starts working again. Then the problem occurs all over.
Sometimes it only takes a few queries before it fails.
We are using sessions in PHP, and there is a session_start() call at the top of each PHP script.
Any clues would be really really appreciated.