7 Replies Latest reply: Nov 23, 2010 4:11 PM by Vlad Gutkovsky RSS

    Script runs but not in Publisher

    Stephen Charles

      I have a qvw that loads data from a Microsoft Access Database table. The script runs find if I manually reload it but it will not reload from a "reload" in Publisher. The error is :

      Error: SQL Error:[Microsoft][ODBC Driver Manager] Data source name not found and no default printer specified SQL State: IM002

       

      Any ideas?

      Thanks,

      Stephen

        • Script runs but not in Publisher
          Vlad Gutkovsky

          Stephen,

          Did you configure the ODBC connection on the server? If so, did you make sure it was a SysDSN and not a UserDSN? When you reload something manually you are doing it with your own username, when Publisher runs a task it does so under its user account.

          Regards,

            • Script runs but not in Publisher
              Stephen Charles

              We have tried to install but Access needs a 32 bit driver and SysDSN seems to only be looking for a 64 bit driver as we are running the QV server and publisher as 64 bit.

              I also did and OLE DB connection and the same thing happens. I can run the reload by publisher can't.

              Any other ideas?

              Stephen

                • Script runs but not in Publisher
                  Vlad Gutkovsky

                  Well, that's the problem. There are no 64-bit drivers for Office. If you want to upgrade to v10, you can simulate a 32-bit connection. If you're using v9 (which is likely), you would have to do the following as a workaround:

                  1. Install QlikView Desktop 32-bit on the server
                  2. Configure a 32-bit SysDSN connection directly from within QV Desktop and configure your script to use that connection
                  3. Test reloading manually to make sure everything works well
                  4. Assuming the reload succeeded, you then need to create a BAT file containing a line in the following format: "C:\Program Files (x86)\Qlikview\Qv.exe" /r "C:\MyQVDocs\Mydoc.qvw"
                  5. Save this BAT file and the configure it as a Supporting Task from QEMC --> System. You can then run it as a task and it will run in 32-bit mode.

                  Note that this is not ideal since you will need to license the local client and waste one of your licenses on that. If that's not acceptable, you need to move away from 64-bit. Either way you would be losing the advantages of 64-bit, but you have Microsoft to blame for that...

                  Regards,