Reload failing sql server error

[Rajiv-Dharia]

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.

[MayilVahanan]

hi

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?

[Rajiv-Dharia]

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.

[Chip_Matejowsky · Accepted solution]

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 ... which details how to configure the DSN.

Best Regards