Wednesday, March 7, 2012

GAMS+GDXXRW under IIS 7 Webserver

Running a GAMS job using GDXXRW from IIS 7 webserver can give several errors.

Cannot create an instance of Excel: Error = Access is denied
Check that Excel is installed correctly.
In case you use the "Click-to-Run" version of Excel, uninstall
this version and install the regular version.


This can be fixed by giving the group IIS_IUSRS permission to use COM automation (via dcomcnfg.exe).


**** Problem opening Excel file: Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space. 
• To make more memory available, close workbooks or programs you no longer need.
• To free disk space, delete files you no longer need from the disk you are saving to


This can be solved by adding a Desktop directory to C:\Windows\SysWOW64\config\systemprofile. See: http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91