When running a reload on our QV server the doucment reloads fine. But on on the QV server when running it in Publisher it say the OLE or ODBC connection failed. We are connecting to a table in a Microsoft Access database.
Please ensure that the ODBC DSN is a 'system' DSN and not a 'user' DSN. The 'user' DSN may work for the user who is connected on the QV server, but may not work for the Publisher user (if they are separate).
Make sure that the DSN name used in QlikView is the same as the DSN you created in system. The best approach would be to delete your user DSN, login and check if you can reload manually.
Please check if your Reload Engine is working (QEMC \ Status \ Services).
One more test could be to change the login ID of 'QlikView Distribution Service' to the ID which you are using to run manually, restart the service and reload. I do not have a publisher with me, so the service name for publisher could be different.
You can't reload from MS Access on the 64 bit server. There isn't a 64 ODBC driver for Access. Either update to version 10 that can interact with both 32 and 64 drivers, or reload through a 32 bit version of QlikView.
