64位Windows系统,ADO连接出错

现象:

1. ADODB.Connectionerror ‘800a0e7a’
Provider cannot be found. It may not be properly installed. 

2. ADODB.Connectionerror ‘800a0ea9’
Provider is not specified and there is no designated default provider.

解决方案:

  1. CSCRIPT %SYSTEMDRIVE%\Inetpub\AdminScripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)

Windows Server 2003TM, Service Pack 1 enables IIS 6.0 to run 32-bit Web applications on 64-bit Windows using the Windows-32-on-Windows-64 (WOW64) compatibility layer. IIS 6.0 using WOW64 is intended to run 32-bit personal productivity applications needed by software developers and administrators, including 32-bit Internet Information Services (IIS) Web applications. For more information about running 32-bit applications on 64-bit Windows, see Running 32-bit Applications on 64-bit Windows.

To enable IIS 6.0 to run 32-bit applications on 64-bit Windows

Open a command prompt and navigate to the %systemdrive%\Inetpub\AdminScripts directory.
Type the following command:

cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 “true”

Press ENTER.

发表评论