topic OLE or ODBC Reload in Publisher Not working in QlikView

OLE or ODBC Reload in Publisher Not working

Mon, 26 Jan 2026 18:19:17 GMT

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

OLE or ODBC Reload in Publisher Not working

Anonymous — Wed, 27 Apr 2011 17:56:25 GMT

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.

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 18:31:57 GMT

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

OLE or ODBC Reload in Publisher Not working

Anonymous — Wed, 27 Apr 2011 18:34:33 GMT

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.

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 18:59:12 GMT

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

Stephen

OLE or ODBC Reload in Publisher Not working

rbecher — Wed, 27 Apr 2011 19:02:20 GMT

Are you running a 64 bit server?

- Ralf

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 19:05:15 GMT

Yes, we are running a 64 bit server.

Stephen

OLE or ODBC Reload in Publisher Not working

Anonymous — Wed, 27 Apr 2011 19:09:44 GMT

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.

OLE or ODBC Reload in Publisher Not working

bnichol — Wed, 27 Apr 2011 19:15:26 GMT

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,

OLE or ODBC Reload in Publisher Not working

rbecher — Wed, 27 Apr 2011 19:20:35 GMT

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

- Ralf

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 19:21:11 GMT

We are aware of the drive isse and we are using the 32 bit ODBC drives.. All of our access databases on the server are working fine.

Stephen

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 19:30:12 GMT

Ralf,

We are running Access 2003 (yes way behind). But if we are using the 32 bit driver, even if on a 64 bit computer, I would think it should work.

Stephen

OLE or ODBC Reload in Publisher Not working

rbecher — Wed, 27 Apr 2011 19:32:28 GMT

Stephen,

this can only work with QVS version 9/10, 32 bit or version 10, 64 bit with Connect32.

- Ralf

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 19:44:03 GMT

We are using QVS 9. Because I can reload manually indicates to me that the 32 bit vs the 64 bit drives is not the issue. Could be wrong.

Stephen

OLE or ODBC Reload in Publisher Not working

rbecher — Wed, 27 Apr 2011 19:50:54 GMT

What means reload manually for you? Using the 32 bit fat client?

- Ralf

OLE or ODBC Reload in Publisher Not working

Wed, 27 Apr 2011 19:59:54 GMT

Manually, for me, means that the docuement, with either OLE or ODBC connections, to the Access database table reloads by all of our users on the QVS. We have made sure that the"system" DSN is being used. But the same document in Publisher will not reload with the error noted earily.

Stephen

OLE or ODBC Reload in Publisher Not working

Denis_Brajkovic — Fri, 29 Apr 2011 18:32:53 GMT

Check your connection string. When created it will automatically use the mapped network drive if the DB isn't stored locally. If that is the case then change the mapped drive to the proper UNC path and the issue should be resolved

OLE or ODBC Reload in Publisher Not working

Fri, 29 Apr 2011 18:45:15 GMT

We are using the UNC path and publisher still doesn't reload.

OLE or ODBC Reload in Publisher Not working

Denis_Brajkovic — Fri, 29 Apr 2011 19:05:42 GMT

OK, then if your QVS is a 64 bit server then use a 64 bit QV Developer. Does it succeed or fail using a 64 bit QV Developer?

OLE or ODBC Reload in Publisher Not working

Fri, 29 Apr 2011 19:18:05 GMT

This will fail because Microsoft Access (2003) for an ODBC connection only has a 32 bit driver.