Auto restarting IIS

using win 2000, asp and mysql.
when i perform a bad sql statement in asp like...

dim cn
set cn = server.CreateObject("adodb.connection")
cn.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=homerton;UID=root;PWD=;OPTION=35"
dim rs
set rs = server.CreateObject("adodb.recordset")
sql = "selec * from tablename" 'note the typo on select
rs.Open sql,cn

IIS complains with
Microsoft VBScript runtime (0x800A01FB)
An exception occurred: 'Open'

If i correct the error IIS still fails to work until i restart the w3svc service. I've tried setting the service recovery properties to restart and to run a batch file on failure but neither do anything.

Anyone know how i can get IIS to restart automatically on such a failure?

I don't know how to autorestart IIS and in a production environment you wouldn't want to.

I'd try to cure the underlying problem in your mysql driver or connection or database. There is no reason to expect your error is a normal occurence.

Yup, i wrongly assumed all our servers were running the same version. For some reason mine was running myodbc 3.51.05 gamma, upgrading to 3.51.06 cured it.