topic Re: DSN not found on task reload in Connectivity & Data Prep

DSN not found on task reload

aschmeelk — Tue, 28 Dec 2021 20:19:39 GMT

Hi folks,

Running Qlik Sense April 2018 release; I have created a 64 bit DSN on our Qlik Central node Server and when I'm in the Data Load Editor of my App, the connection works fine. It's when I create a Task to reload the App that I get the following Error: Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I have verified ownership, the DSN, basically everything I can think of, why would the Reload Task fail in QMC when the App loads without errors from it's Data Load Editor?

Completely stumped here!

Re: DSN not found on task reload

jwjackso — Mon, 06 May 2019 22:04:03 GMT

Is it a System DSN?

Re: DSN not found on task reload

aschmeelk — Mon, 06 May 2019 23:03:02 GMT

Yes system dsn

Re: DSN not found on task reload

prashanthi_gn — Tue, 07 May 2019 00:30:04 GMT

what kind of driver is that?

If its a Oracle , then can you please check if there is tnsnames.ora file in the networks/adimin folder.

Re: DSN not found on task reload

prashanthi_gn — Tue, 07 May 2019 00:31:23 GMT

Also make sure the driver is configured in all the nodes.

Re: DSN not found on task reload

jonathandienst — Tue, 07 May 2019 05:08:32 GMT

When you ran the reload successfully from Data Manager, were you working with Desktop or were you opening the app from your workspace on the hub?

Re: DSN not found on task reload

aschmeelk — Tue, 07 May 2019 11:18:02 GMT

My workspace on the Hub.

Re: DSN not found on task reload

aschmeelk — Tue, 07 May 2019 11:18:47 GMT

No, not Oracle. MySQL driver.

Re: DSN not found on task reload

aschmeelk — Tue, 07 May 2019 11:53:35 GMT

That was it! I had forgotten to create the DSN on our Rim node. Thank you!

Re: DSN not found on task reload

jamshed07 — Thu, 15 Oct 2020 07:46:23 GMT

Your answer save my day. That's worked for me too, create the DSN on our Rim node