Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Edit Connection (ODBC)

Hello,

I have a question around configuring Qlik Sense on Windows 10.

I usually install Qlik on Windows 7 PC and one of the steps I make is to go to 'Edit Connection (ODBC) > User DSN' where there is normally a check box to the left of "Use 32 Bit Connection" that I tick and then save form.

I have installed Qlik on a Win 10 PC and this check box is not there (see pic).

Is that because of Win 10 or am I overlooking or missing something?

Thank

Danny

4 Replies
bwisealiahmad
Partner - Specialist
Partner - Specialist

Hi,


Have you created a User DNS? There is none in the list there so when you have one in your list and press it I think you can tick off Use 32-bit?

You are sure it is a User DNS and not a System DNS?

Helga_W
Employee
Employee

I am using Qlik Sense Feb 2018 on Windows 10 64 bit. The option to use a 32 bit connection is available for me when I create a User DSN ODBC connection.

Anonymous
Not applicable
Author

Hi Helga,

I downloaded the Feb 2018 version and still get the same issue. From your screenshot it appears you have the checkbox ion on the "Create New Connection" form, do you see that checkbox if you edit the connection?

The other thing I'm doing differently is I'm not creating connection in Qlik rather I create Firebird ODBC connection to PTReport Table which is populating correctly in the correct field in Qlik its just that checkbox is still missing when I edit the connection.

Helga_W
Employee
Employee

Hi Danny,

there is no User DSN in your list, that means you did not create an ODBC connection yet. When you create a User or System DSN you must choose in Windows 10 whether it's a 32-bit or 64-bit connection.

Although I have several User DSNs in Windows, none of them shows up when I select "User DSN" in the ODBC connection creation dialog in Qlik Sense.

I suggest you contact support with your issue.

Helga