Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator 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
Highlighted
Creator III
Creator III

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.

Highlighted
Creator III
Creator III

Thanks Bindu.

How can I check that?

Highlighted
Partner
Partner

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

Highlighted
Creator III
Creator III

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

Highlighted
Creator
Creator

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

Luminary
Luminary

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