Are you using IIS 4 or upper, because IIS 3 don´t support asp (as soon as you applied a path).
If you are IIS 4 the option Executing(Including the script) at Site/proprietes/base folder/permissions must be enabled. Check the permission, documents/enable default document (the put the first page that must be viewed). If the ODBC is configured Ok, and the ASP file is right It will run