Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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.

Highlighted
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