topic Re: Reload failing sql server error in QlikView

Reload failing sql server error

Rajiv-Dharia — Mon, 26 Jan 2026 21:26:37 GMT

Hi,

Need help with the data reload as qmc tasks are failing giving the below error message.

SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
ODBC CONNECT TO QLikView (XUserId is cMYGcIRNJbaMXUVMXbUCFGJKFLYIWSJOPC, XPassword is dFbOWIZKTKcYGZVMBDZCDaA)

I tried to install new drivers also ODBC driver for SQL server. still tasks are failing.

Re: Reload failing sql server error

MayilVahanan — Wed, 21 Sep 2022 05:34:26 GMT

Its in ur local or server, check the ODBC driver is installed and configure correctly.

Do you have data source name as "Qlikview" in Database?

Re: Reload failing sql server error

Rajiv-Dharia — Wed, 21 Sep 2022 06:56:21 GMT

Yes we have two Qlik View Servers One is Production Server and this one Development server where we have QVD's to load data. I tried to reinstall the ODBC drivers also yesterday but it did not fix the problem.

Re: Reload failing sql server error

Chip_Matejowsky — Wed, 21 Sep 2022 11:26:24 GMT

Hi @Rajiv-Dharia,

The returned error is what QlikView is receiving from the source. The QlikView Engine cannot find a corresponding or the correct ODBC driver. Typically not an error in the Qlik product, but an issue with the environment configuration. QlikView is unable to find the correct ODBC driver or an incorrect one is configured.

Have a look at the Qlik Support article Reload fails with error "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" which details how to configure the DSN.

Best Regards