从IIS 6.0迁移到IIS 8.5后，“找不到提供程序”错误 [英] “Provider cannot be found” error after migrating from IIS 6.0 to IIS 8.5

问题描述

我有一个ASP站点，在Windows Server 2003& IIS 6.0。我迁移到Windows Server 2012 R2 IIS 8.5



我在尝试连接数据库时遇到错误：



无法找到提供商。它可能没有正确安装



错误详情：

2014-11-05 10:33:06 10.30.62.21 POST _main.asp | 50 | 800a0e7a | Provider_cannot_be_found._It_may_not_be_properly_installed。 80 - XX.XX.XX.XX Mozilla / 4.0 +（兼容; + MSIE + 7.0; + Windows + NT + 6.1; + WOW64; + Trident / 5.0; + SLCC2; +。NET + CLR + 2.0.50727; + .NET + CLR + 3.5.30729; +。NET + CLR + 3.0.30729; +。NET4.0C; +。NET4.0E; +。NET + CLR + 1.1.4322; + InfoPath.3）/bottomright.asp ？sAction = assist 500 0 0 1859



我的连接字符串如下：



GetConnectionString =Provider = SQLNCLI.1; Data Source =& m_DALServer& _

;用户ID =用户;密码= pwd;连接超时= 3;



我已检查过新服务器（2012）上的ODBC数据源管理员（32位），下面找到两个相关的驱动程序



SQL Native Client 2005.90.4035.00 Microsoft Corporation SQLNCLI.DLL

SQL Server 6.03.9600.163.84 Microsoft Corporation SQLSRV32.DLL

我已将我的应用程序池启用为32位，托管管道启用为Classic。

I have a ASP site which is working fine on Windows Server 2003 & IIS 6.0. I migrated to Windows Server 2012 R2 IIS 8.5

I am getting an error when it tries to connect to a database:

Provider cannot be found. It may not be properly installed

Error Details:
2014-11-05 10:33:06 10.30.62.21 POST _main.asp |50|800a0e7a|Provider_cannot_be_found._It_may_not_be_properly_installed. 80 - XX.XX.XX.XX Mozilla/4.0+(compatible;+MSIE+7.0;+Windows+NT+6.1;+WOW64;+Trident/5.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729;+.NET4.0C;+.NET4.0E;+.NET+CLR+1.1.4322;+InfoPath.3) /bottomright.asp?sAction=assist 500 0 0 1859

My connection string is as below:

GetConnectionString = "Provider=SQLNCLI.1;Data Source=" & m_DALServer & _
";User Id=user;Password=pwd;Connect Timeout=3;"

I have checked the ODBC Data Source Administrator (32 bit) on new server(2012) and found below two related drivers

SQL Native Client 2005.90.4035.00 Microsoft Corporation SQLNCLI.DLL
SQL Server 6.03.9600.163.84 Microsoft Corporation SQLSRV32.DLL
I have enabled my app pool to 32 bit and Managed Pipeline to Classic.

推荐答案

技术支持团队安装的一些驱动程序。哪些司机我不确定。但是由于我在ODBC源中看到 SQL Server Native Client 10 的补丁，我的问题在没有任何代码更改的情况下得到了解决。



谢谢所有你的时间。

Some drivers where installed by Tech Support Team. Which drivers I am not sure. But because of the patches I saw SQL Server Native Client 10 available in ODBC sources and my issue was resolved without any code change.

Thanks all for your time.

尝试在你的连接字符串中将提供者更改为 SQLNCLI10.1 。

Try changing the provider to SQLNCLI10.1 in your connection string.

这篇关于从IIS 6.0迁移到IIS 8.5后，“找不到提供程序”错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！