| Author |
 Topic  |
|
|
sherware
Starting Member
USA
10 Posts |
 Posted - 01 August 2005 : 15:22:01
|
Help!
My forum just started getting this error last night:
Microsoft JET Database Engine error '80004005'
Unspecified error
/forums/inc_header.asp, line 112
I have done research on this forum and other asp forums to try to find an answer before posting.
The server is here in our office and nothing has changed on it; no updates, no new software...nothing.
- I have rebooted the server twice. Still doesn't work.
- I've moved the MDB files to another location and changed the config.
- I setup a DSN and changed the config to use it. The message changed by adding "Not enough Disk Space"
- I changed inc_header.asp to include: my_conn.mode = 3, that's why the error is on line 112 instead of 111.
- I've checked permissions on the folder the MDB file is stored in. IUSR_WIN2003XP has complete access to it.
- Just to make sure it wasn't a permissions problem, I added EVERYONE with full access to the folder the MDB is in. It didn't make a difference.
- I've changed the environment variables for TEMP and TMP and made sure the folder they were pointing to was accessible to IUSR_WIN2003XP.
- I've opened the database and disabled the option under Advanced: "Open databases with record level locking"
Can someone help me? I don't know what else to try.
Here's the link: http://www.sherware.com/forums/
Thanks,
Phil Sherwood
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
sherware
Starting Member
USA
10 Posts |
Posted - 01 August 2005 : 18:13:12
|
| I tried the snitz_forums_200.mdb database. It had the same problems. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Shadow69
Starting Member
18 Posts |
Posted - 01 August 2005 : 20:02:45
|
| just wandering, did you have a dsn-less, if not did you test that? (setup.asp gives you the same error) |
Image, we want only honest people, here! You will NEVER get back! |
|
|
|
sherware
Starting Member
USA
10 Posts |
Posted - 01 August 2005 : 20:55:08
|
I'm not familiar enough with MySQL or SQLServer enough to set it up and transfer my forums to that format.
The current setup is dsn-less. I tried setting up a DSN and the message changes to "Not enough disk space". |
|
|
|
Shadow69
Starting Member
18 Posts |
Posted - 02 August 2005 : 03:24:26
|
Out of nothing this is a very nasty one to diagnose...
1) have you checked Event Viewer to see if you had any warnings since the problem arised?
2) i don't know if it would make a difference trying the access 97 connection string, but it can't hert
3) i suppose you are using 2003 server IIS6, what MDAC version is installed? |
Image, we want only honest people, here! You will NEVER get back! |
Edited by - Shadow69 on 02 August 2005 05:08:27 |
|
|
|
sherware
Starting Member
USA
10 Posts |
Posted - 02 August 2005 : 06:13:31
|
1) There's nothing in Event Viewer.
2) I've tried the access 97 connection string and had the same error.
3) It is 2003 Server and IIS6. MDAC version is 2.80.1022
Thanks,
Phil
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 02 August 2005 : 07:11:49
|
I always use DSNless connections. Those unspecified errors are tough to solve, thus my suggestion, and even more so because Access and Windows 2003 don't always get along so well.
Anyway, you are sure there is no problem with disk space? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
sherware
Starting Member
USA
10 Posts |
Posted - 02 August 2005 : 08:16:04
|
There's over 164Gb free.
Is there a utility that will take an access database to a MySQL Server database? |
|
|
|
Shadow69
Starting Member
18 Posts |
Posted - 02 August 2005 : 10:53:18
|
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=42438 (Search Button)
are You giving forfait already? some more checks to do
1) are disk quotas enabled?
2) what if you change db name in connection string to a non existent one, would the error be the same?
3) check history at microsoftupdate (former windowsupdate) to see if anything was downloaded and installed since the problem happened.
4) do you have other apps which make use of access dbs? (too many concurrent connections or connections left open)
*5) wasn't there a limit of 16 tables in access dbs?
I also hope these tools may be handy, they are for me:
http://www.sysinternals.com/search/default.aspx?query=80004005
fingers crossed  |
Image, we want only honest people, here! You will NEVER get back! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
sherware
Starting Member
USA
10 Posts |
Posted - 02 August 2005 : 12:34:10
|
Disk quotas was the culprit. Evidently, the install of 2003 Server sets a 1Gb limit on disk space. Not sure how the anonomyous user got over 1Gb, but that's something else to check out.
Everything is working now. Thanks for your help!
Phil |
|
|
|
Shadow69
Starting Member
18 Posts |
Posted - 02 August 2005 : 13:31:27
|
Bingo!
I knew rurib put us on the correct path
happy to know it's fixed! |
Image, we want only honest people, here! You will NEVER get back! |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
