从IIS 6.0迁移到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.