Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

master_student
Contributor III

Data source name not found and no default driver specified

Hello community,

I get the error bellow when executing a reload task in QMC :


ODBC CONNECT32*XUserId*XPassword*

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

Execution Failed

Do you have any idea please?

Thanks

6 Replies
bindu_apte
Contributor III

Re: Data source name not found and no default driver specified

Hi,

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.

master_student
Contributor III

Re: Data source name not found and no default driver specified

Thanks Bindu.

How can I check that?

Partner
Partner

Re: Data source name not found and no default driver specified

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:

Andy

bindu_apte
Contributor III

Re: Data source name not found and no default driver specified

Hi,

Please find the screenshot where you need to create new system DSN.

Control Panel\System and Security\Administrative Tools\Data Sources (ODBC)

DSN.jpg

vinod22kv
Contributor

Re: Data source name not found and no default driver specified

Thanks a lot for your reply it help me a lot....

Highlighted
Luminary
Luminary

Re: Data source name not found and no default driver specified

Hi

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