Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OLE or ODBC Reload in Publisher Not working

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.

Any ideas?

Thanks,

Stephen

26 Replies
Anonymous
Not applicable
Author

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).

Regards,

Dinesh.

Not applicable
Author

I am (now) and still get the error. Specifically the error for the ODBC connection is:

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

We are on version 9.0.7469.8

Stephen

Anonymous
Not applicable
Author

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.

Regards,

Dinesh.

Not applicable
Author

I removed the user DSN and reload mannually works but still not in publisher.

Stephen

rbecher
MVP
MVP

Are you running a 64 bit server?

- Ralf

Astrato.io Head of R&D
Not applicable
Author

Yes, we are running a 64 bit server.

Stephen

Anonymous
Not applicable
Author

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.

Regards,

Dinesh.

bnichol
Specialist
Specialist

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.

Cheers,

B

rbecher
MVP
MVP

..this was my intention to ask. But there is a 64 bit MS Access 2010 version, but I'd never used it.

- Ralf

Astrato.io Head of R&D