topic Load task via QMC fails with ODBC in QlikView

Load task via QMC fails with ODBC

dbouilleux1 — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

On a server SBE without Publisher, I try to plan the loading of a QVW. This QVWuses data of a database accessible via an ODBC driver.

When I load the document by the Desktop, all goes well.

But the load operation implemented via the QMC, using the same user, fails.

In the log file, we find the following error :

ODBC CONNECT*

02/06/2015 09:57:39: Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié

02/06/2015 09:57:39: General Script Error

02/06/2015 09:57:39: Execution Failed

Do you have an indication of what causes this error?

Thank you for your feedback

Re: Load task via QMC fails with ODBC

vardhancse — Tue, 02 Jun 2015 08:33:12 GMT

QlikView QMC service accounts should have access to fetch the data from data base,

grant access to Qlikview service accounts to the DB tables/views.

Then there will be no error

Re: Load task via QMC fails with ODBC

Peter_Cammaert — Tue, 02 Jun 2015 08:53:50 GMT

I think it may have more to do with the fact that the Distribution Service cannot find the specified ODBC connection. The main difference between OLEDB and ODBC is that OLEDB only requires an installed dirver and all settings are passed through the CONNECT statement. ODBC however requires you to define an ODBC DSN in Windows first. There is a control panel app for this in Administrative Tools.

Peter