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: