Ok, this might be quite simple. You say you are using ASP, well...modify your Connection String to be:

"Provider=MSDASQL;DSN=MyDSN;UID=MyUser;PWD=MyPassword"

If that works then you know that the ODBC must be deleting...