I have an automated agent that connects to a db2 server via ODBC. It is failing to connect, but if I run it manually from the same client and using the same user id, it runs without a hitch. Is there some difference in the environment that I am missing?
Subject: ODBC Connection failure in automated agent
did you create your ODBC connections on the server and test them? When you run it manually it uses the ODBC connections you setup on your PC, when it runs scheduled it’s going o use the ODBC connections setup on the server.
Subject: RE: ODBC Connection failure in automated agent
I thought about this too, but Wade says “I run it manually from the same client” - I suppose this means that he has the Notes client installed on the server.
Could it be an agent security issue?
Subject: RE: ODBC Connection failure in automated agent
There is a replica on a client box that is always up. The agents run on this box. I remotely logged into the box and ran it manually under the same user which has signed the agent, and it worked. When running on the schedule, the connection fails.
Additionally…I copied the agent to my laptop’s client, signed it and scheduled it…and it ran just fine. I thought this must mean that the ODBC configuration was the problem, but I have duplicated the settings, and the agent still fails when running scheduled from the other client.
Subject: RE: ODBC Connection failure in automated agent
You never mentioned the OS (kind of important) so I will assume it is XP.
In XP there are two types of ODBC connections. There is User which is only avaliable to the user that installed the connection. And there is System, which is avaliable to all accounts on the server.
If the ODBC connection is User, the server runs under a service and the service uses a different ID than the one you use to log into the server then you would have this problem.
Subject: RE: ODBC Connection failure in automated agent
It’s Windows 2000 server on the problem machine…the ODBC is registered as a system data source, so everyone should be able to use it. Additionally, I am logging in (via Ultra VNC) with the same user that signed the automated agent. I cannot for the life of me figure this out.
Subject: RE: ODBC Connection failure in automated agent
So, did I get you right in that there is no Domino server installed, just a client configured to run schedule local agents?
What exact error do you get and where do you get it from? Local log.nsf?
System data source should be the correct one to use.
Subject: RE: ODBC Connection failure in automated agent
Sorry…should have come back and posted sooner…it was a client system running agents against a replica of a server based db…it turns out that the client system was hosed up and needed to be rebooted…after reboot, the agent worked just fine.