We have deployed a solution in a Windows Server 2003 64-bit using ASP.NET 2.0, and in our website we have a feature that reads an XLS file uploaded from a client user.
I read some forums, but in none of them a reasonable solution was found.
I tried the following:
1 - Compile our solution (its projects - VS2005) in x86, but IIS response was "Service Unavailable".
2 - Install the Jet 4.0 SP8 for Windows 64-bits (KB829558). The installation process stops with the following message: "\update\update.exe" is valid, but is for a machine type other than the current machine". I think it's instruction set incompatibility, but I could not find the SP8 download for x64 architecture.
3 - Use the version 12.0 (changing the connection string properly), but it was not able to read the XLS 2003 format, raising the same Exception.
I have some urgeny on this issue, because it is in final test phase and it's expected to have 1.6 million users on the website (Live@edu large deployment).
What is the best solution for this issue?