iis problem (Microsoft JET Database Engine error '80004005')

[keytenkele]

i have a iis problem that we could not solve.... you are guru about this subject and i hope you could help me...
my problem is that we serve 180 sites on server those sites generally use asp and access mdb database.. when sites normally running server gives that message :

Microsoft JET Database Engine error '80004005'

Unspecified error

/inc_qua.asp, line 3

we take this error message only sites those use asp and mdb but not others.. than we restart server after this action the sites return normally we could not solve this problem... i hope you could help me...

a friend says me about this problem "in access database promise 10 connection at same time..."

how can i decrease this connect number... opposite we must control all time server...

this problem maked firstly after we setup Windows 2003 Standart Edition R2 ...

thank you....

http://www.normworks.com

 

[monksnake]

I did a google search and found this:
URL -

http://tutorials.aspfaq.com/8000xxxxx-errors/80004005-errors.html

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x9ac Thread 0xa0c DBC 0x15d1024 Jet'.

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] General error Unable to open registry key 'DriverId'.

or

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

or

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Disk or network error.

or

Microsoft JET Database Engine error '80004005'
Disk or Network error

or

Provider error '80004005'
Unspecified error

or

Microsoft JET Database Engine error '80004005'
Unspecified error

Again, IUSR_<machineName> must have read and write permissions not only on the MDB file, but also on the folder in which it resides, and in some cases the system %TEMP% folder. See Article #2154 and KB #315456 for more information. If you are trying to access a network drive, see Article #2168 for information on setting up IUSR_<machineName> to connect to an Access database via a UNC share. You should also check out Article #2142 for information on opening Access in the correct mode (e.g. adModeReadWrite).

There are certain situations where you will need to set up permissions for the IWAM_<machineName> user as well. Specifically, the C:\document and settings\%domainname%\IWAM_localmachine\local settings\temp folder. Thanks to Sylvain Paquin for pointing this out to us!

If you are not using anonymous access, but rather Windows Authentication, you want to be sure that all potential users are in a Windows group that has sufficient privileges on the folder on the web site where the MDB files resides. You might have to update individual permissions systematically if you are unable to do so via group membership.

If you are getting "unspecified error" then try running the IIS site in its own memory space or, if it is already doing so, returning it to the normal memory pool. Another possibility is the symptom described in KB #225042.

Finally, Access can produce the "unspecified error" message if you use reserved words anywhere in your SQL statement (see Article #2080 for a list of reserved words).

Sounds like a permissions/privileges issue to me, since it started after you set up Windows 2003.


<.