I think you should also review your data access code and make sure that
all of your connections are being closed on every page. Just one page
with a still open connection can hang you up like this depending on how
often it is called. Do not rely on the garbage collector to close it for
you.
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"James Frankman" <jfrankman@stripped> wrote on 07/29/2004 01:13:04 PM:
> We have MySQL 4.0 running on our IIS web server. Occasionally, IIS
> crashes and after restarting the server, we get the error message:
>
> '' Microsoft OLE DB Provider for ODBC Drivers [MySQL][ODBC 3.51
> Driver]Host 'xxx.xxx.xxx.xxx' is blocked because of many connection
> errors. Unblock with 'mysqladmin fulsh-hosts' "
>
> Other connections to MySQL work, only connections from IIS to MySQL
> fail until the MySQL service is restarted. I have not tried 'flush
> hosts' since at the time I wasn't familiar with the command, and I
> was under the gun to get our Intranet back up. Restarting MySQL was
> my quickest option
>
> A couple questions:
>
> 1. Is 'mysqladmin flush-hosts' equivelant to the mysql command 'flush
hosts'?
> 2. How can I avoid this problem in the future?
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=1
>
