急，求求高手了

[yybb520]

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC Microsoft Access Driver]常见错误 不能打开注册表关键字 'Temporary (volatile) Jet DSN for process 0xcc8 Thread 0xdd4 DBC 0x16b3b44 Jet'。
这是为什么啊？我用的Access的数据库，同样的链接文件，在别一个页面就能用，可这个页面为什么不能呢？高手帮忙啊!

[什么都不能]

养成好习惯，读完数据库，要关闭数据集，连接，并清除对象占用的空间

[cqhunter]

楼上说的在理，不过要排除你的错误的话，还是要贴出你的代码才行。

[yybb520]

我关了链接，而且将对像设置成nothing然后再关机，重起，还是一样的错误，有一个添加页面能用得上!可其它的就不行!我要怎么解决呢？ASP真烦，一直做.net的三层开发，专门做了链接池管理这个又怎么办？？？急啊!

[zhanghongwen]

贴代码出来,不然没办法帮你.

[jspadmin]

换用其他连接方式

[sky0120]

这种问题很普遍，也很棘手。很多人都是重装了操作系统才解决。微软提供的解决方案是修改注册表，但效果好象也不好。

当然也有可能是你的代码有问题，所以贴出来看看。

[sky0120]

从国外站点搜到的资料：
Error codes in ASP can drive you crazy sometimes. (的确让人很疯狂)How do you fix it if you see the error "Temporary volatile Jet DSN for process - Unable to open Registry key "（下面看看他怎么说的）?

First, this in general means there is a permission problem getting to the database. （存取数据库权限问题？）
Usually this happens when you do a security patch on your server（给系统打安全补丁了吗）, reboot your server（重启动了？）, or install firewall software（安装了防火墙软件？）. All of these things can cause your web user to lose permission to access the critical files（所有这些原因都可能导致WEB用户丧失访问文件的许可）.

So first, check the basics. Make sure that IUSR has write permission to both the directory holding the database file and to any temp directories being used（检查IUSER权限）. Make sure that the DSN connection string is actually pointed at the diretory you are working on（确定DSN连接字符串指向正确的工作目录）!

Even if you thought these were set properly, a reboot or a security upgrade might have unset them（检查安全更新，这也可能引起该问题）. Check again.

Next, look into any other security blocks that may have been added（检查其他任何被加载的安全模块）. Have you added any antivirus or firewall software recently（最近是否添加了任何防病毒或防火墙软件）? Try turning it off and see if that helps（关掉它们看是否有效果）. If it does, turn the software back on and then go into its configuration（如果确实是这些软件的问题那么打开它并进入软件设置项）, and allow access to the directories in question（打开访问相关目录的权限）.

[yybb520]

呵呵，问题解决了，原因是我用的链接驱动方式得不到支持了，
我原来用的链接驱如下DRIVER={Microsoft Access Driver (*.mdb
然后再改成
Provider=Microsoft.Jet.OLEDB.4.0;问题就解决了！
谢谢以上各位的回复和关注！谢谢了！

[sky0120]

1、the webserver environment needs "write" permission to the directory where the Access database resides. So, set permissions first. Go to Windows Explorer, Tools, Folder Options, View and turn off the very last entry in the list ("Use simple file sharing") if you haven't already done so.

2、Now, you'll have a "Security" tab when you right-click on a folder. Make sure you give write permission to the folder with the MS Access database to the "IUSR_***" account (with *** being your computer's name). This account is used by IIS, per default, to evaluate permissions for the default access to your local PWS website and scripts.



3、Give the same user IUSR_<machine name> (or whatever is the default account) access to the TEMP directory of Windows. MS Access might need to write some stuff there.

4、Give the same account write permission in MS Access itself. These permissions can be reset by MS Access if you compact and repair the database so keep in mind to refresh this permission as necessary.

5、If you still get the error "[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process", check that the database is really in the directory referenced by the DSN or the connection string in your ASP file! Also, check for misspellings in the file name. This was the reason for the error when I ran into it earlier this week.

Hope this helps...