Kbase P126906: ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provi
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/11/2007 |
|
Status: Unverified
FACT(s) (Environment):
Progress/OpenEdge Versions
Windows x64
SYMPTOM(s):
ADODB.Connection error '800a0ea9' Provider is not specified and there is no designated default provider.
64bit IIS will not run with 32bit OBDC drivers.
Using 32 bit version ODBC manager executable from C:\WINDOWS\SysWOW64\odbcad32.exe
CAUSE:
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.
On 64-bit Windows, 32-bit processes cannot load 64-bit DLLs, and 64-bit processes cannot load 32-bit DLLs. If you plan to run 32-bit applications on 64-bit Windows, you must configure IIS to create 32-bit worker processes.
FIX:
32 bit reporting service can be supported on 64-bit IIS. (Please see note for limitations before attempting these steps.)
To install 32 bit reporting Service on 64-bit IIS 6.0:
If necessary, uninstall the 64-bit version of Reporting Services. Side-by-side deployment of 64-bit and 32-bit versions is not supported.
Run dotnetfx64.exe to install the Microsoft .NET Framework manually. You can find this file in the Redist folder on the SQL Server 2005 Setup media, or you can download it from Microsoft .NET Framework Version 2.0 Redistributable Package (x64) on the Microsoft download site.
In IIS Manager, click the Web Server Extensions folder.
In the Details pane, right-click ASP.NET V2.0.50727, and then click Allowed.
Right-click the Web Sites folder and then select Properties.
Click ISAPI Filters.
In Filter Name, select ASP.NET_2.0.50727, and then click Edit.
Replace "C:\WINDOWS\Microsoft.NET\Framework64\v2.0.50727\aspnet_filter.dll" with the 32-bit version that is located in the Framework folder: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll.
Click OK. Save your changes, and close IIS Manager.
Open a command prompt window, and then run the following command:
cscript %SystemDrive%\inetpub\AdminScripts\adsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
Install the 32-bit version of Reporting Services.
After Setup is complete, open IIS Manager, click the Web Server Extensions folder.
In the Details pane, right-click ASP.NET V2.0.50727 (32-bit), and then click Allowed.