Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Partner
Partner

ODBC Excel won't work still with all the information I found on Qlik and Internet

Hi Qlik forum,

I'm struggling to connect an Excelsheet for user directory purposes. I read a lot where others facing problems but still it won't work for me.

My customer have QlikSense Enterprise November 2018. No Microsoft package on server. Windows 64 bit but I need a 32 bit ODBC.

What have I done?

1. Uninstall my 2016 version and Installed the 2010 version Microsoft Access Engine:

2019-02-09_0815.png

2. Created a SYSTEM DSN with the 2010 version

system_dsn.png

3. Created a test app in Hub and make connection. It worked and is see data

4. Created an Excel ODBC user directory and names of sheet are matching

2019-02-09_0819.png

5. Getting the famous message "Exception when trying to connect to the data source. Edit the connection string in the user directory connector configuration "

6. I checked the log and see also this "Setting up UDC'EXCEL' of type Repository.UserDirectoryConnectors.ODBC.OdbcExcel unsuccessful ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified↵↓Exception when trying to connect to the data source. Edit the connection string in the user directory connector configuration"

7. Ok, I understand that Qlik can not find the data source name and no driver is specified. So I tried this and other message appear "The specified DSN contains an architecture mismatch between the Driver and Application"

2019-02-09_0825.png

Recap: I have a working Excel ODBC connection because i see the data in my app. But if i want to connect to an UDC, Qlik tells me that no DSN of driver is found or a mismatch in string. If I check ODBC then I see the driver in SYSTEM.

Can anybody help me please. I need this for my customer because some persons doesn't work through the the also existing Active Directory connection and need Qlik.

ps: I'm not a connection string specialist so maybe here lies the problem. I looked through some articles and it seems not that hard to manage this. But still it won't work for me 😉 

Thank you in advance!

Martijn Wanders

Labels (5)
3 Replies
mofqlikproject
New Contributor

Re: ODBC Excel won't work still with all the information I found on Qlik and Internet

you are using ODBC to connect xls

you can just create lib path it does same 

Partner
Partner

Re: ODBC Excel won't work still with all the information I found on Qlik and Internet

Hi,

Thank you for your reply. I don't understand how I can use your answers.

you are using ODBC to connect xls >> Do I have to connect an xls file instead of .xlsx? Tried this but same message.

you can just create lib path it does same >>  Do I use the LIB path which I created in App? Do I put this string LIB CONNECT TO 'Excel User database (xxxxx)'; in visible connection string? Tried this but same message.

Or do I make a mistake?

Kind regards,

M. Wanders 

 

 

 

Partner
Partner

Re: ODBC Excel won't work still with all the information I found on Qlik and Internet

Hi,

I posted my question in another forum (managing and deploying) I there was the solution to install the 64bit version. This worked. Thank you for helping me. Have a nice day!