Solved: Re: ODBC Connection Issue. - Qlik Community

prashantbaste · ‎2016-12-20

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 ...!

jonathandienst · ‎2016-12-20

>>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

varshavig12 · ‎2016-12-20

check - Force 32 bit

varshavig12 · ‎2016-12-20

Let me know if this works

prashantbaste · ‎2016-12-20

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.

awhitfield · ‎2016-12-20

Have you created 32 or 64 bit ODBC connection?

Andy

ramasaisaksoft · ‎2016-12-20

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.

prashantbaste · ‎2016-12-20

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

prashantbaste · ‎2016-12-20

It is compulsory & necessary to restart machine?

awhitfield · ‎2016-12-20

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

Andy

awhitfield · ‎2016-12-20

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

Andy