Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 819
  • Last Modified:

Microsoft JET Database Engine error '80004005' Unspecified error

My Win 2000 server crashed last night.  Upon a hard reboot my website asp pages are served but any page that need to get data from my MS Access 2000 Databases are throwing the following error:

Microsoft JET Database Engine error '80004005'

Unspecified error

I hunted through Google but could find any specific instructions on troubleshooting this problem?  Can someone help me?
0
cdemott33
Asked:
cdemott33
  • 4
  • 4
  • 2
1 Solution
 
rentoncCommented:
Can you supply your connection strings and what page you initially get he errors from.
0
 
aprestoCommented:
Also, try and open your database in its MS Access environment, and make sure the database itself is not corrupted. This can often be the case when access is terminated in a server enrieonment unexpectedly
0
 
cdemott33Author Commented:
I don't believe it has anything to do with the connection string, because, up to the point of my server crashing, the connection strings have been in place for at least a year, working perfectly.  Then, on hard reboot, it just stopped working.

I think it has something to do with the server crash and hard reboot?  Something is preventing my ASP code from connecting to the database.  Something on the server.

There are about 5 website on my server.  Each website has it own unique database (mdb) and each website is throwing the same error message.  So whatever it is, it's affect all the databases and not just a single database.

Any other thoughts?   Again, it is MS Acess 2000 running on a Windows 2000 server.  Is there some way of checking to see if the system put a lock on all the databases or something?  I'm sorry, but I don't know very much about server administration so I really do need help.  Thanks!


0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
aprestoCommented:
download one of the databases and try and access it from the MS Access environment. do you have backups?
0
 
rentoncCommented:
Send the connection string really! It all helps, because we aren't mind readers! :)
0
 
cdemott33Author Commented:
Hi apresto - I tried that and I am able to open the databases via the MS Access environment.  I haven't added anything to the tables that I opened I just made sure I could open them and read the data, which I can.  
0
 
rentoncCommented:
I would also try reinstalling MDAC again as this may have been corrupted.
0
 
cdemott33Author Commented:
As requested here's an example.  It uses a UDL file to connect to the database
	' From adovbs.inc:
	Const adOpenKeyset = 1
	Const adLockPessimistic = 2
	Const adCmdText = &H0001
 
	' Get filename and build SQL query
	strSQLStatement = "SELECT * FROM Login;"
 
	' Open our recordset
	Set strFilename = Server.CreateObject("ADODB.Recordset")
 
	' Access version:
	strFilename.Open strSQLStatement , _
		"File Name=C:\Inetpub\wwwroot\UDLFiles\ClientA_Database.udl", _
		adOpenKeyset, adLockPessimistic, adCmdText
 
	If NOT strFilename.EOF Then
		strFilename.MoveFirst
	End If
 
	' PERFORM STUFF
 
	' Close our connection
	strFilename.Close
	Set strFilename = Nothing	

Open in new window

0
 
rentoncCommented:
Try using a DSNless connection
0
 
cdemott33Author Commented:
Well I reboot the server,which seams to have "magically" resoloved the problem.  I would have prefered to get to the root cause of the issue, but I could not have the websites unavailable for any extended lenght of time.

I really don't believe it has anything to do with the connection string because I've been using the same exact method of connecting to the database for 2 years now and I haven't had any trouble at all.  

I believe that when the server crash/froze up and I hard booted it something got "Lock" and prevented the connections from working.  I have no idea what could have done that, but, for now, a soft reboot seamed to clear things up.

Thank you all for your suggestions.  Hopefully this will not happen again, any time soon.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now