Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikconsultant
Creator II
Creator II

How install the EXCEL ODBC in the System DNS?

I try to connect an Excel file via ODBC

SET DateiV=D:\Data\file1.xlsx;

ODBC CONNECT32 TO [Excel Files;DBQ=$(DateiV)];

But I get an error message:

ODBC error

Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

ODBC CONNECT32 TO ***

 

The driver is only installed in the User DSN.

What do I have to do, to see it in the System DSN?

2 Replies
martinpohl
Partner
Partner

so you have to create the odbc connection in the odbc 32 administration console

martinpohl_0-1618397588839.png

Regards

qlikconsultant
Creator II
Creator II
Author

Yes I know I tried this:

1.PNG

 Put in the name:

2.PNG

And then I the same error:

ODBC error

Connector connect error: SQL##f - SqlState: IM002, ErrorCode: 0, ErrorMsg: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

ODBC CONNECT32 TO ***

So something what  i'm doing is wrong. But not sure what.