Load task via QMC fails with ODBC

[dbouilleux1]

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

[vardhancse]

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

[Peter_Cammaert]

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