Discussion Board for collaboration related to QlikView App Development.
I get the error bellow when executing a reload task in QMC :
Error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
General Script Error
Do you have any idea please?
It´s important to create your ODBC entry as System, not User so all users can connect to your ODBC entry.
Check that the ODBC is a System DSN. If not, then it won't work.
How can I check that?
That looks like an incomplete connection string, there's no actual name of the ODBC connection in it! how have you created it? Try using the Connect option:
Please find the screenshot where you need to create new system DSN.
Control Panel\System and Security\Administrative Tools\Data Sources (ODBC)
Thanks a lot for your reply it help me a lot....
I have a brief guide on setting up ODBC on my blog
It may be of help - it also gives a brief explanation of how you can use it in excel - useful for verifying data quickly before you start your script builds
ODBC Setup and Use | Adrian Worrall’s Qlik Sense & Excel Blog