System.InvalidCastException: QueryInterface for interface Excel._Application failed.
Posted on 2006-04-19
This one has me stumped, hopefully not for much longer. Here is the situation: A .NET web application pulls data into a sql data reader , then creates, populates, and saves an Excel File. This error is being thrown when the application runs on the server. This error does not occur when it is in the debugger. I even created a modified version of the program to run on my development box (release version) and ran it with no problems. So it looks like the object cannot be created on the server Windows 2000 for some reason, here is the kicker: It has been working fine for about two years and suddenly broke. Any ideas?
Thanks in advance-