Skip navigation
Currently Being Moderated

64 bit server error creating data import connection type

VERSION 1 
Created on: Nov 12, 2008 4:53 PM by philw - Last Modified:  Nov 12, 2008 4:53 PM by philw
Question

Windows Server 2003 x64 bit o/s.  Error creating import connection type for Excel spreadsheet - When trying to save the connection type get an error The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine.

Answer

It is trying to load 64bit dll which does not exist.

 

Microsoft article which explains how to switch to ASP.NET to 32 bit, which seems to correct the problem:

 

http://support.microsoft.com/kb/894435

 

These are the instructions used were :

 

ASP.NET 2.0, 32-bit version

 

To run the 32-bit version of ASP.NET 2.0, follow these steps:

1.      Click Start, click Run, type cmd, and then click OK.     

2.      Type the following command to enable the 32-bit mode: cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET

W3SVC/AppPools/Enable32bitAppOnWin64 1

3.      Type the following command to install the version of ASP.NET 2.0 (32-bit) and to install the script maps at the IIS root and under: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i

4.      Make sure that the status of ASP.NET version 2.0.50727 (32-bit) is set to Allowed in the Web service extension list in Internet Information Services Manager.

Environment

Windows Server 2003 x64  ServiceDesk 7.2.4 R1

 

Comments (8)
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software