Thanks for your replies!
I guess the ODBC connection isn't a issue. Even when creating a job that reloads a simple application which loads a .QVD from the local disk doesn't work. I think it has something to do with rights.
Do you know how to change the user that is running the Publisher?
To test whether it is the user:
Do a run as... on QlikView and reload the application using the userid that is running the services. If it fails than it is a user rights issue.
To change the user running QlikView Services:
Under Administrative Tools > Services you can change the Publisher Execution Service user there under Properties > Log On. It's best to create a local admin user who has log on as service rights then make this user to run all of your QlikView services. Make sure this user has ntfs access to the source documents folder as well as the distribution folder(s) and accesspoint folder(s). Also be sure to add this user to the QlikView Administrators group.
New user will not take effect until services are restarted.
hope this helps!