Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
thonipad
Contributor III

OLE or ODBC Reload in Publisher Not working

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

OLE or ODBC Reload in Publisher Not working

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

thonipad
Contributor III

OLE or ODBC Reload in Publisher Not working

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

OLE or ODBC Reload in Publisher Not working

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

Stephen

MVP
MVP

OLE or ODBC Reload in Publisher Not working

Are you running a 64 bit server?

- Ralf

Not applicable

OLE or ODBC Reload in Publisher Not working

Yes, we are running a 64 bit server.

Stephen

thonipad
Contributor III

OLE or ODBC Reload in Publisher Not working

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
Valued Contributor

OLE or ODBC Reload in Publisher Not working

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

MVP
MVP

OLE or ODBC Reload in Publisher Not working

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

- Ralf

Community Browser