We have an agent that runs on our database to get contact records from our AS400 system and update the records in our Lotus Notes database. If I run this agent from Actions menu it works just fine but when I schedule it to run everyday, it gives this error message on the log file:
AMgr: Agent ('AgentName' in 'DatabaseNamet.nsf') message box: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
We have the Data source hard coded in the agent and in my PC, I've setup an ODBC connection from the ODBC Administrator to match the name so I guess that's why I can do it manually. Does that mean I have to have the ODBC connection set up on the server too for the agent to run on schedule?