Aargh!! Unspecified errors randomly!

Using ASP under IIS5 on Windows 2000 Server (latest patches and MDAC).

OK, intermittently when I try writing a record to an Access database, I'm
getting the phantom "Provider error '80004005' Unspecified error" on a
connection Execute method call. When it works, it works perfectly. For
example, I can fill out the form, hit Save, and the record writes perfectly.
Fill out the form again, and whammo! Sometimes refreshing the page will
cause the record to be written correctly, but usually I keep getting the
Unspecified Error. Both IWAM_ and IUSR_ have
write permissions to both the system Temp directory and to the directory
where the Access database is stored, in addition to the file itself.
The fact that write occassionally work but not others tells me that it isn't
a privileges problem. I've been to ASPFAQ.com, and didn't find anything
useful that I haven't already checked.

Help! This is driving me nuts!


Jack

Re: Aargh!! Unspecified errors randomly!

JackBlack wrote:
> Using ASP under IIS5 on Windows 2000 Server (latest patches and MDAC).
>
> OK, intermittently when I try writing a record to an Access database,
> I'm getting the phantom "Provider error '80004005' Unspecified error"
> on a connection Execute method call. When it works, it works
> perfectly.
This is usually caused by an error in the data. We can't tell what's wrong
without seeing what you're doing ...
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Aargh!! Unspecified errors randomly!

"JackBlack" wrote in message news:uldBkbHSGHA.1728@TK2MSFTNGP11.phx.gbl...
: Using ASP under IIS5 on Windows 2000 Server (latest patches and MDAC).
:
: OK, intermittently when I try writing a record to an Access database, I'm
: getting the phantom "Provider error '80004005' Unspecified error" on a
: connection Execute method call. When it works, it works perfectly. For
: example, I can fill out the form, hit Save, and the record writes
perfectly.
: Fill out the form again, and whammo! Sometimes refreshing the page will
: cause the record to be written correctly, but usually I keep getting the
: Unspecified Error. Both IWAM_ and IUSR_ have
: write permissions to both the system Temp directory and to the directory
: where the Access database is stored, in addition to the file itself.
: The fact that write occassionally work but not others tells me that it
isn't
: a privileges problem. I've been to ASPFAQ.com, and didn't find anything
: useful that I haven't already checked.
:
: Help! This is driving me nuts!

MODIFY permissions on the folder that contains the DB, not WRITE.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp