ASP + ACCESS数据库：Microsoft Jet数据库引擎错误“80004005”未指定的错误 [英] Asp Access db: Microsoft JET Database Engine error '80004005' Unspecified error

问题描述

服务器是专门的，我有远程访问。

Server is dedicated and I have remote access.

我们有自定义的ASP CMS与Access数据库和我们使用的MOD改写自定义错误页。它的伟大工程。

We have custom ASP CMS with Access database and we use custom error pages for "mod rewrite". It works great.

这个网站是在6种不同的语言，每一种语言都有它自己的域，它们都连接到同一个数据库中。

This website is available in 6 different languages and each language has its own domain and they all connect to the same database.

问题是，我得到这个错误每隔几个小时：

Problem is, I get this error every few hours:

Microsoft Jet数据库引擎错误80004005结果
  未指定的错误

Microsoft JET Database Engine error '80004005'
Unspecified error

在我得到这个错误我必须重新启动IIS或编辑错误页面设置来详细的错误，然后再次将其设置为自定义。之后，它工作正常。

After I get this error I have to restart IIS or edit "Error pages settings" to detailed error and then set it again to custom. After that it works fine.

我安装过程监控和跟踪我w3wp.exe的审判。

I have Process monitor installed and I track w3wp.exe proces.

在错误ocurs我拒绝访问的 HKLM \\ SOFTWARE \\ Wow6432Node \\微软\\喷气\\ 4.0 \\发动机。

When error ocurs I got Access denied on HKLM\SOFTWARE\Wow6432Node\Microsoft\Jet\4.0\Engines.

感谢您。

推荐答案

Access数据库从来没有对高话务量而建，很可能只是由于崩溃请求的数量庞大。

Access database was never built for high volume traffic, most likely it just crash due to sheer amount of requests.

您真不如切换到真正的databae，这几天你有免费的许多包括SQL Server防爆preSS，MySQL和其它更多的。

You really better switch to real databae, these days you have great many for free including SQL Server Express, MySQL and lots more.

在此期间你可以通过你的code，并确保您：

In the meantime you can go through your code and make sure you:

1. 始终使用它，然后将其设置为Nothing例如后立即关闭记录集。

1. Always close the Recordset right after using it then Setting it to Nothing e.g.

Do Until oRS.EOF
    'do your stuff...
    oRS.MoveNext
Loop

'Always close after use
oRS.Close
Set oRS = Nothing

同样的Connection对象：关闭，当你用它处理完

Same for Connection object: close and dispose when you are finished with it.

很多时候，页面使用重定向 - 确保重定向例如之前关闭和处置

Many times pages use Redirect - make sure to close and dispose before redirecting e.g.

If oRS.EOF Then
    'Always close after use
    oRS.Close
    Set oRS = Nothing

    Response.Redirect("Error.asp?v=nouser")
End If

'do your stuff...

'Always close after use
oRS.Close
Set oRS = Nothing

这篇关于ASP + ACCESS数据库：Microsoft Jet数据库引擎错误“80004005”未指定的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！