Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Partner
Partner

ODBC Connection Issue.

Hi All,

I have created system DSN to connect MySQL database (thru Administrative Tool) & it get "Connection Successful" message when I try thru ODBC Drivers.

But When I come into Qlikview it do not show SystemDSN to connect. And If I select User DSN that is not successful to get connect me to database.

Can anyone suggest what can be issue?

Thanks in advance ...!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: ODBC Connection Issue.

>>Its 32 bit connection & QV is also of 32 bit version.


I think you created a 64 bit connection. The default ODBC tools on a 64 bit machine create a 64 bit DSN which cannot be seen by 32 bit applications.


Make sure you run this version to create 32 bit connections on 64 bit Windows:

     C:\Windows\SysWow64\odbcad32.exe


This version makes 64 bit connections on 64 bit (and 32 bit connections on 32 bit Windows):
     C:\Windows\System32\odbcad32.exe


And those are not typos. Some MS engineer was having a really bad day when those naming conventions were developed.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

17 Replies
varshavig12
Valued Contributor

Re: ODBC Connection Issue.

check - Force 32 bit

varshavig12
Valued Contributor

Re: ODBC Connection Issue.

Let me know if this works

Partner
Partner

Re: ODBC Connection Issue.

Hi Varsha Vig‌,

Thank you for your valuable input.

But I tried in both ways (with Force 32 Bit & without Force 32 Bit), but it still do not show list of System-DSNs in connection box.

Partner
Partner

Re: ODBC Connection Issue.

Have you created 32 or 64 bit ODBC connection?

Andy

ramasaisaksoft
Valued Contributor III

Re: ODBC Connection Issue.

Hi Prashant,

some times after creation of System DSN you need to restart your machine.

try it once and let me back if u still face the issue.

Partner
Partner

Re: ODBC Connection Issue.

Hi Andrew Whitfield‌,

Its 32 bit connection & QV is also of 32 bit version.

Partner
Partner

Re: ODBC Connection Issue.

Hi Rama Sai,

It is compulsory & necessary to restart machine?

Partner
Partner

Re: ODBC Connection Issue.

Just tried on my PC and the System DSN was available  immediately, has you got Force 32 bit checked?

Andy

Partner
Partner

Re: ODBC Connection Issue.

Have you checked to see if the DSN is available in Tools ODBC Administrator in the script edit screen?

Andy