A friendly reminder: if you are running Lotus Domino 32-bit on a Windows Server x64 (64-bit) and need to use ODBC, then you need to define your ODBC data sources in the 32-bit ODBC Administrator program – and not in the standard 64-bit ODBC Administrator program. This is because the Lotus Domino ODBC drivers are 32-bit.
The 32-bit ODBC Administrator program is located at C:\Windows\SysWOW64\ODBCAD32.exe.
A customer of mine uses Lotusscript and the Microsoft Excel object to create Excel spreadsheets with scheduled agents. The code is based on the normal way of creating spreadsheets – e.g.:
Set ExcelApp = CreateObject("Excel.Application")
Set ExcelWorkbook = ExcelApp.Workbooks.Open("C:test.xls")
Set ExcelWorksheet = ExcelWorkbook.Application.Workbooks(1).Worksheets(1)
The scheduled agents worked fine on a Windows Server 2003. The application was then installed on a freshly installed Domino server running on a freshly installed Windows Server 2008 x64 (64 bit) and then the scheduled agents started failing with the following error message: “SaveAs method of Workbook class failed“.
After several tries of fixing the code I finally found the simple (but unexpected) solution to the problem: create a folder called “Desktop” in C:\Windows\SysWOW64\config\systemprofile\.
Yes, that’s it! just create the folder and then the code starts working again 🙂