64 bit server error creating data import connection type

    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