Data source name not found and no default driver specified

[master_student]

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

[bindu_apte]

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]

Thanks Bindu.

How can I check that?

[awhitfield]

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 · Accepted solution]

Hi,

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

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

[vinod22kv]

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

[aworrall · Accepted solution]

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

[Chip_Matejowsky · Accepted solution]

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

Best Regards