Lotus Notes 6.0x And Windows Server 2003

[Andrew22]

In spite of advice to the contrary we must migrate Lotus Notes off an AS/400 to a Wintel platform. The current application has some automatic agents that utilize MYSQL commands and run fine when native to the 400, but running from the 2003 server the ODBC agents do not work.

1. Has anyone else moved to a 2003 server platform?
&
2. Any ideas on where to look for help with the agents?

IBM has been no help as the agents is home spun. It has been re-written from scratch by our admin and an outside consultant with no success.

THANKS in advance.

[mike2011]

First you should have to define a DSN for the MYSQL server using ODBC Administrator.