DSN not found on task reload

[aschmeelk]

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!

[jwjackso]

Is it a System DSN?

[aschmeelk]

Yes system dsn

[prashanthi_gn]

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.

[prashanthi_gn · Accepted solution]

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

[jonathandienst]

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?

[aschmeelk]

My workspace on the Hub.

[aschmeelk]

No, not Oracle. MySQL driver.

[aschmeelk]

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

[jamshed07]

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