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.
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:
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
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.
Windows Server 2003 x64 ServiceDesk 7.2.4 R1