[thelist] IIS ASP puzzler

Dougal Campbell dougal at gunters.org
Tue Feb 25 16:45:00 CST 2003

On Tue, 25 Feb 2003, Anthony Baratta wrote:

> At 02:03 PM 2/25/2003, Dougal Campbell wrote:
> >By liberal use of "On Error Goto Next" and "On Error Goto 0", I've
> >determined that the object creation for ADODB.Recordset and
> >CDONTS.NewMail succeed. The failure doesn't occur until we try to call
> >'objRS.Update' or 'objMsg.Send'.
> Are you getting *any* error messages with your code? Have you done a
> diff/compare between a working page and the non-working page to verify the
> code has not changed?

I get an ASP error indicating that the recordset cursor could not be
updated. The ASP code is identical between the two versions on this
particular server. And the *exactly identical* code runs find on our
test server. The problem is not in the ASP code, it is somewhere higher
in the hierarchy of IIS.

One (totally invented) theory that one of our developers had was that
perhaps the IUSR_foo anonymous account somehow has read access to those
components, but not write access. But I haven't found anything yet that
would support that idea.

We've also tried deleting the directory's application settings from the
Transaction Server settings in the MMC, then recreating them under the
IIS settings. But that didn't clear the problem up either.

Ernest MacDougal Campbell III, MCP+I, MCSE <dougal at gunters.org>
http://dougal.gunters.org/             http://spam.gunters.org/
  Web Design & Development:  http://www.mentalcollective.com/
       This message is guaranteed to be 100% eror frea!

More information about the thelist mailing list