80004005 unspecified error suddenly stops page working

[mackers2]

I've got some asp pages connecting to MS Access databases (some are Access 2000, some are Access 2). Suddenly this afternoon I've got 80004005 errors on all pages that try to get data from an Access database.

Anybody any ideas why this would happen suddenly - I've not lost RW access to the folders where the databases are(I've checked with FileSystemObject).
Thanks
Alasdair

 

[DreXor]

actual error , line number, and possible the sourcecode surrounding the errored line would be extremely beneficial.

we may be really smart, but we are far from clairvoyant



DreX
aKa - Robert

 

[mackers2]

<%

Set LocADO = Server.CreateObject ("ADODB.Connection")
LocADO.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "\\pharm-svr\Train\dispdata.237\wait2.mdb"

Crashes out on line beginning LocADO above (according to browser).

This is just an example of one page; all the other pages on the site accessing MS Access databases have stopped as well, presumably on similar lines.


Worked till 3.30pm then stopped. Any ideas?

 

[DreXor]

probably persmissions were changed
or someone on the network may have opened the DB directly, hence locking out internet

also iusr_webservername needs to be in the permissions of the folder housing the mdb file, with change permissions.

permissions may have been reset, if you have frontpage extentions installed, it may have done a routine security reset and altered permissions, or someone may have been tinkering on the network.

DreX
aKa - Robert

 

[mackers2]

Thanks, do you know where I should start looking - there are at least three different databases, some stored on web server, one on other servers, but they've all stopped working. I know the account asp pages are using to access the databases is OK to read/write the database folders as I tested that with a FileSystemObject script.

Any help appreciated.

 

[DreXor]

check the DB houseing folder(s) permissions, ensure the iusr_webserver ( webserver being whatever machine name your web server is ) has change permissions on said folders.


DreX
aKa - Robert

 

[DreXor]

another thing to check for out of sheer chance, check with everyone with access to the server and see if anything was installed recently on the machine, like around 3 oclock

DreX
aKa - Robert

 

[mackers2]

thanks, DreXor, any joy and I'll post
Alasdair

 

[mackers2]

Reset the permissions now and the funny thing now is that the pages run fine for the webmaster but when an ordinary user tries to use it they have the same error.
Alasdair

 

[DreXor]

still permissions then especially with the admin ok but no one else


DreX
aKa - Robert

 

[mackers2]

ok, fixed now:
tracked down what was going wrong (all the Access databases being used on the whole intranet were down) by changing from OLEDB to ODBC driver which then errored with message about Volatile Jet DSN ...

MS KB indicated this was permission problem with the Jet driver on the web server - Jet creating temporary files and not having the right permissions. Jet tries to write to windows TEMP files in TEMP or TMP environment settings. Somehow (?) these folders had become inaccessible to the web page user account.

So... tried to reset the permissions, but I think the web guys just tried to do this directly, and this doesn't work always - you have to use XCOPY to change the permissions on a copy of the folder, then copy it back using XCOPY or windows resets the permissions to the default inherited permissions after that.

When we used XCOPY it's all fine.

Sorry explanation's a bit poor, hope it helps anybody else who has same problem.

 

[DreXor]

thanks for the update/resolution

andvery glad to hear u got things chuggin again :-D

DreX
aKa - Robert