I setup a task to reload the document. I can see that the status shows as failed, but dont know where to look at the logs to find out where the error message is. I did setup the ODBC connection in the server and I can manually refresh the document in the server as well.
Found the problem. The ODBC connection was setup with my personal ID as a USER DSN instead of a SYSTEM DSN. Hence the punlisher windows account could not find my USER DSN. I changed it to a SYSTEM DSN & I am all set now.
