topic Re: Not able to reload task which has odbc connection in QlikView

Not able to reload task which has odbc connection

Mon, 26 Jan 2026 18:19:17 GMT

i have created a qvw file where i have created an ODBC connection and calling some stored procedure

in my set up , i have QMC installed in one server A and only publisher installed in another server B

I have SQL Server connectivity available only in Publisher Server and am able to reload my qvw manually successfully and get data.

Now i am trying to Reload this qvw using task in QMC in Server A. but the task is failing as it is not able to connect to ODBC Data source.

Note : QMC SERVER A does not have connectivity to SQL Server database.

Could you please let me know what i am missing here

Re: Not able to reload task which has odbc connection

awhitfield — Fri, 26 Jun 2015 13:22:24 GMT

Hi Binod,

Have you created the odbc connection on the server too?

Andy

Re: Not able to reload task which has odbc connection

giakoum — Fri, 26 Jun 2015 13:26:28 GMT

the reload is done by the server the publisher is on.

So that server needs to have teh ODBC connection

Is it one server or a cluster?

Re: Not able to reload task which has odbc connection

Gabriel — Fri, 26 Jun 2015 13:39:03 GMT

Hi,

You have to create the ODBC connection string from QMC server A.

Re: Not able to reload task which has odbc connection

Fri, 26 Jun 2015 18:13:55 GMT

No we don't have connectivity to SQL SERVER through ODBC on QV SERVER

Re: Not able to reload task which has odbc connection

maxgro — Fri, 26 Jun 2015 18:29:31 GMT

The publisher reloads the data; you only need (to reload) connectivity to sql server from the publisher.

When you say manually, do you mean manually from the publisher server?

Enable the log in your QlikView document (Menù --> settings --> document properties --> general --> generate logfile) save the doc on your server (source folder), reload from qmc and post the log you find in the same folder as the .qvw doc (same name, end .log suffix)

Or try yourself to see in the log, the error is at the end.

Re: Not able to reload task which has odbc connection

Fri, 26 Jun 2015 18:48:19 GMT

yes manually from publisher the qvw file is in publisher

Re: Not able to reload task which has odbc connection

Peter_Cammaert — Mon, 29 Jun 2015 12:34:21 GMT

Can you post a screenshot of the Interface you use to "manually reload the qvw from publisher"? Running a manual reload in QV Desktop doesn't count.

Peter