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

Data source name not found and no default driver specified

master_student — Wed, 15 Jun 2016 10:22:43 GMT

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

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

bindu_apte — Wed, 15 Jun 2016 10:33:17 GMT

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.

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

master_student — Wed, 15 Jun 2016 10:35:10 GMT

Thanks Bindu.

How can I check that?

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

awhitfield — Wed, 15 Jun 2016 10:38:44 GMT

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

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

bindu_apte — Wed, 15 Jun 2016 10:41:29 GMT

Hi,

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

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

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

vinod22kv — Tue, 19 Jun 2018 17:47:27 GMT

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

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

aworrall — Tue, 19 Jun 2018 18:57:06 GMT

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

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

Chip_Matejowsky — Wed, 08 Mar 2023 12:43:21 GMT

Article https://community.qlik.com/t5/Official-Support-Articles/Connector-connect-error-SQL-f-SqlState-IM002-ErrorCode-0/ta-p/1710225 is for Qlik Sense but in this case also applies to QlikView.

Best Regards