I recently migrated one of our Lotus Notes databases over to a new Windows 2008 64 bit server. This database was previously on a Windows 2003 32 bit server. The database contains scheduled agents that query our DB2/400 files on our iSeries box via ODBC and then compose emails displaying the data in tables.
When these agents run now on the new 64bit server, all numeric values show up in the tables but for some reason, the text values are not displaying.
I'm guessing the problem has to stem from the ODBC drivers on the server? I checked the system DSN's on both the Windows 2003 32bit and Windows 2008 64 bit servers and they're setup identically.
Any advice is appreciated. Thanks,