用于 ODBC 驱动程序的 OLE DB 提供程序错误“80004005" [英] OLE DB Provider for ODBC Drivers Error "80004005'

问题描述

我必须将一些客户站点从一个非常旧的 IIS 服务器移到一个较新的服务器，而一些站点无法以正确的方式工作.他们中的大多数人抱怨失败，称为:

I have to move some customer sites from a very old IIS Server to a newer one, and some sites have troubles to work in the correct way. Most of them complain about a failure called:

用于 ODBC 驱动程序的 Microsoft OLE DB 提供程序错误80004005"

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager]未找到数据源名称且未指定默认驱动程序.

[Microsoft][ODBC Driver Manager]Data source name not found and no default driver specified.

我在互联网上了解到，这可能取决于授予用户的权限缺失；其他网站指出缺少 Temp 文件夹(我无法想象这是正确的)......还有其他几个解决方案":

I've read on the internet that this could depend on missing rights given to the user; other sites states that a Temp folder is missing (I can't imagine that this is right)… There are several other "solutions":

为服务器上的每个人开放权限(正如某人所说)对我来说不是一个选项.此外，为每个客户赋予明确的权利是非常痛苦的(有几个客户需要这些权利).

Open the rights for everyone on the server (as someone stated) is not an option for me. Also it is very painful to give explicit rights to every customer (there are several customers which needs the rights).

您知道更简单的解决方案、类似的方法或替代方法吗?

Do you know an easier solution, a similar way, or an alternative?

推荐答案

我在使用经典 asp 和 IBM DB2 ODBC Driver 时遇到了类似的问题.我确实在我的本地 IIS 7.5 中配置了两个网站，Connection.Open 在默认网站上运行良好，而在第二个网站上却没有，根据我的知识和建议进行了几次配置更改在这种情况下，来自 stackoverflow 并没有帮助我.

I have got the similar issue while working with classic asp and with IBM DB2 ODBC Driver. I do have two websites configured in my local IIS 7.5, Connection.Open is working fine with default web site whereas it does not with the second website, after several configuration changes as per my knowledge and as per sugesions from stackoverflow did not helped me in this case.

对我有用的是启用(设置为 True)32bit 应用程序 ASP.NET V4.0 经典应用程序池的高级设置.

What worked for me is to enable (Set to True) the 32bit applications Advanced setting of ASP.NET V4.0 Classic Application Pool.

Application Pools-->ASP.NET V4.0 Classic-->
           Advanced Settings--> under General Options double click Enable 32-bit Applications to set to True.

这个小配置可能会对遇到同样问题的人有所帮助.

This small configuration may help some one who has the same issue.

这篇关于用于 ODBC 驱动程序的 OLE DB 提供程序错误“80004005"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！